Hello all,
I have a range of cells containing customers' first names preceded by a space (" "), and am attempting to remove said space.
All of my searches keep digging up the same solution: =RIGHT(A1, LEN(A1)-1). Excel rejects this as invalid. I can't use =LEFT due to the varying length of names, so this would seem to be the ideal formula.
The cell range is General, automatic recalculation is checked. I'm using Microsoft Office Professional Plus 2010. Can someone tell me what I'm missing?
Welcome to the forum!
Have you tried this:
=TRIM(A1)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
That worked perfectly!
No idea why every search I did only produced the other option--this was simple as could be.
Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks