Hi,
If have a lot of names in excel with a space at the end. The space is causing errors in other formula cells.
Is there a way to use formulas to copy the name but delete the last space?
My data is like this
"" illustrate text in my cells.
"James Johnson "
"Adam Emil "
I want it like this
"James Johnson"
"Adam Emil"
So i just want to get rid of that last space.
Use
Trim function
=Trim("James Johnson ")
or
=left("James Johnson ",len("James Johnson ")-1)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Awesome, thanks a lot!
OR
=REPLACE(B1,LEN(B1),1,)
This will remove the last character no matter what it is.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Would it be easier to use the find & replace (ctrl+f) function in excel?
Select the column/row/range of cells and the use find <space>" and replace all with just "
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks