how to remove spacing in between text

  • Thread starter Calculate Date range
  • Start date
C

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.
 
S

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
 
C

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
 
J

Jacob Skaria

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


If this post helps click Yes
 
S

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
 
R

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.
 
C

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.
 
Top