Comma, lower case Letter

[Manolocs]

Hello I need the first letter after a comma to be lower case, any help is more than welcome

 

[AliGW]

Provide some sample data!

 

[admiral100]

Hi,


try this

=SUBSTITUTE(A1,MID(A1,FIND(",",A1)+1,1),LOWER(MID(A1,FIND(",",A1)+1,1)))

 

[Rick Rothstein]

Hello I need the first letter after a comma to be lower case, any help is more than welcome

I am with AliGW on this... you are going to have to show several examples of the kind of text you are dealing with. One thing I am particularly interested in is if there can be more than one comma in the text.

 

[Manolocs]

@Rick Rotstein, is only the first comma there will be more than one comma but normally we use lower case after comma, with minimum exceptions. Thank you for your time.

 

[Manolocs]

@admiral100, this formula did not work
This is an example of what I need:
The man is old, He is 90 years old = The man is old, he is 90 years old

 

[Manolocs]

@AliGW, sorry for the lack of information:
This is an example of what I need:
The man is old, He is 90 years old = The man is old, he is 90 years old

 

[admiral100]

=substitute(a1,mid(a1,find(",",a1)+2,1),lower(mid(a1,find(",",a1)+2,1)))

 

[Rick Rothstein]

=substitute(a1,mid(a1,find(",",a1)+2,1),lower(mid(a1,find(",",a1)+2,1)))

If you change your formula to this, it will not error out if the sentence does not contain a comma...

=SUBSTITUTE(A1,MID(A1,FIND(",",A1&",")+2,1),LOWER(MID(A1,FIND(",",A1&",")+2,1)))

Here is a shorter formula (one less function call) that will work the same...

=REPLACE(A1,FIND(",",A1&",")+2,1,LOWER(MID(A1,FIND(",",A1&",")+2,1)))