Thanks:  0
Likes:  0

# Thread: Delete all white space between the words in one cell

1. I know that there is a TRIM function that delete extra space between words in a cell. How do you delete all space in a cell.
ex. "White Space" == "WhiteSpace" Is there a function for it, that is similiar to TRIM function?
Thank you.

2. Hiya,

=Substitute(A2," ","")

3. ## Re: Delete all white space between the words in one cell

=UPPER(CONCATENATE((TRIM(LEFT(A1,2))),(RIGHT(A1,5))))
eg. ND 10552 = ND10552

4. ## Re: Delete all white space between the words in one cell

Originally Posted by umvahed
=UPPER(CONCATENATE((TRIM(LEFT(A1,2))),(RIGHT(A1,5))))
eg. ND 10552 = ND10552
This only works if the data you want to keep is in the leftmost two and rightmost five positions in the string. It will turn "White Space" into "WHSPACE" which isn't exactly what Elisa was asking for.

Also, why are you using UPPER?

Still, she'll be deeply moved by the fact that we're still reading her posts after nine years!

5. ## Re: Delete all white space between the words in one cell

You can adjust the "2" to the desired length of your strings. Wont work for different lengths. Unless u use a LEN function somehow....lol ya, i saw it this year only!!

6. ## Re: Delete all white space between the words in one cell

Nice!! The Substitute formula worked perfectly!!
Woohooo!!

7. ## Re: Delete all white space between the words in one cell

Perfect! The "Substitute" formula worked a treat!

8. ## Re: Delete all white space between the words in one cell

Substitute Formula Really waorks Thanks

9. ## Re: Delete all white space between the words in one cell

substitute is a great method

10. ## Re: Delete all white space between the words in one cell

Originally Posted by Asala42
Hiya,

=Substitute(A2," ","")

Thank you for sharing this formula. it helps a lot.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•