how to remove spacing in between text
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.
|