LinkBack URL
About LinkBacks
Hi all,
I have a col. of name like
Peter
John
Sami
There are some invisible blank leading space after the name, how can I delete all of that leading spaces in excel at automatically?
Thanks all for your help,
VBisgreat
Hi all,
I have a col. of name like
Peter
John
Sami
There are some invisible blank leading space after the name, how can I delete all of that leading spaces in excel at automatically?
Thanks all for your help,
VBisgreat
it depends on what that leading space actually is....
If you enter a formula like: =CODE(LEFT(A1)) where A1 contains a leading space, what does it return?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
65 is the output
That is for uppercase "A" are you sure the first character is a space of some sort or are you talking about trailing spaces?
see attached for example, click on the cell and you will see that there are spaces after each word.
Those are trailing spaces.
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
Simply select the column and go to Edit|Replace
Then enter a space in the Find What and leave the Replace With field
Click Replace All
That will work but if I have a compound word like dave smith, I don't want the space between dave and smith get remove.
Last edited by VBisgreat; 04-06-2011 at 12:14 PM.
Try using
CTRL+H
That will work but if I have a compound word like dave smith, I don't want the space between dave and smith get remove. This is a long list to do by hand. Thanks!!!
VBisgreat
Then in an adjacent column you would enter a formula like:
=TRIM(A2) copied down, where A2 contains first string.
Then you can copy this column and paste special >> Values over the original column and delete the helper.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks