how to remove spacing in between text

[Calculate Date range]

I need to remove the spacing in between comma and capital L

Chan, Lucy-CS

Can anyone help me on this

Thanks.

 

[Sheeloo]

If that is the only space you can use Find and Replace
Enter a blank in FIND What
and nothing in REPLACE With

Select the range you want to update and press CTRL-H

 

[Calculate Date range]

Hi Sheelo,

I have who list of names (about 200) need to remove the blank spacing
between comma and First name.

example,

Chan, Lucy-CS
Ahmad, Ali Bin
Lee, Apple
Joe, Daniel

to become

Chan,Lucy-CS
Ahmad,Ali Bin
Lee,Apple
Joe,Daniel

Please advise how to set the formula so that the spacing in the name list
will be removed.

Thanks

 

[Jacob Skaria]

=LEFT(A1,FIND(",",A1)) & TRIM(MID(A1,FIND(",",A1)+1,100))


If this post helps click Yes

 

[Sheeloo]

You don't need a formula
Select the cells with the names
Press CTRL-h to open Find/Replace dialog
enter a comma followed by a space in FIND What
enter only a comma in REPLACE With
Click REPLACE ALL

Do keep a copy before attempting this

 

[Rick Rothstein]

If this is a one-time thing, then I would do what Sheeloo suggested.
However, if you need your solution in a formula...

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

Change A1 to the address of the first cell containing a name and copy it
down from there.

 

[Calculate Date range]

Hi Jacob,

thanks.

Sorry, If I want the spacing to be inserted between comma and First name

Example ,

Chan,Lucy-CS
Ahmad,Ali Bin
Lee,Apple
Joe,Daniel

become

Chan, Lucy-CS
Ahmad, Ali Bin
Lee, Apple
Joe, Daniel

How's the formula looks like.

Thanks.