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

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Calculate Date range" wrote:

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


"Sheeloo" wrote:

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
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Calculate Date range" wrote:

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

Chan, Lucy-CS

Can anyone help me on this

Thanks.