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

Chan, Lucy-CS

Can anyone help me on this

Thanks.

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.

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.

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


If this post helps click Yes
---------------
Jacob Skaria


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

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.

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.

--
Rick (MVP - Excel)


"Calculate Date range" wrote
in message ...
I need to remove the spacing in between comma and capital L

Chan, Lucy-CS

Can anyone help me on this

Thanks.

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.


"Jacob Skaria" wrote:

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


If this post helps click Yes
---------------
Jacob Skaria


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