|
|
|
|
Remove leading space
On 24/10/05 2:03 PM, in article
, "Karidre"
wrote:
I wonder if someone can help me with this...it's driving me crazy.
I need to delete a leading space from multiple cells, 200 or more. The
leading space is in front of text that is often more than one word so I can't
just copy into Word and do a find and replace on the spaces.
I looked in many places for help and found out about the Trim function but
when I tried it, it didn't work for me. Am I doing it wrong? I created a
column next to the column that I want to remove the leading spaces from. then
I put =TRIM(B2) in the first cell, =TRIM (B3) in the next one, etc. But all
it did was put the exact same thing as before (with the leading space still
in it) in that column?
Any suggestions? Thanks!
- Kari
Try :- Insert an empty column on the right of your Data, select the column
you want to fix. Go to top menu- Data, Text to column, This will show you a
preview of the text You wish to fix. Click next, Click the checkbox space,
Click next, click finish. Done. Then You can copy data back to where you
want it.
Paul
|