Hi experts,
Trim is the WorksheetFunction which removes all extra spaces, but leaves one between words.
I am looking for WorksheetFunction which removes all extra spaces and also removes all spaces between words.
I need excel formula not vba.
Thank you.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
So you want to get rid of ALL spaces?
Formula:
Please Login or Register to view this content.
BSB
So in other words, remove ALL spaces.
Try
=SUBSTITUTE(A1," ","")
Like that?Please Login or Register to view this content.
EDIT:
Dang, ninja'd, although I like it when we all independently agree on the best answer.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Interesting.
The problem/solution in that thread is VERY different from the issue you described in your original post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks