I need a function for excel to convert to camel case-CodePudding

I need a function for excel which would convert

'random.text.random'

'randomTextRandom'

CodePudding user response：

Assuming your value is in cell A1 ...

=LOWER(LEFT(A1,1)) & MID(SUBSTITUTE(PROPER(SUBSTITUTE(A1,"."," "))," ",""),2,LEN(A1))

... or if you're expected to have the first character capitalized ...

=UPPER(LEFT(A1,1)) & MID(SUBSTITUTE(PROPER(SUBSTITUTE(A1,"."," "))," ",""),2,LEN(A1))

CodePudding user response：

Try below formula-

=SUBSTITUTE(PROPER(A1),".","")

CodePudding user response：

Since i have mentioned in comments above hence adding the same in the answers as well, also you can use Upper or Lower or Proper as per your requirement basically you needed to remove the dot and just concatenate without it

Formula used in cell B1

=SUBSTITUTE(A1,".","")

CodePudding user response：

Convert to Camel Case

=LEFT(A1,FIND(".",A1)-1)&SUBSTITUTE(PROPER(RIGHT(A1,LEN(A1)-FIND(".",A1))),".","") = randomTextRandom

To the left of the first dot:
```
LEFT(A1,FIND(".",A1)-1) = random
```

To the right of the first dot:

RIGHT(A1,LEN(A1)-FIND(".",A1)) = text.random

Make it proper:
```
PROPER(...) = Text.Random
```
Remove the remaining dot:
```
SUBSTITUTE(...,".","") = TextRandom
```