Remove Space in Text

G

Guest

I know how the "trim" function works, but is there a function in excel to
remove all the space in text? Example would be

from "281P 358" to "281P358"

Thanks
 
G

Guest

Formula example assumes that the value you want to strip the spaces from is
in A1:


=SUBSTITUTE(A1," ","")
 
G

Guest

Try this:

For text in A1

B1: =SUBSTITUTE(A1," ","")
Removes ALL spaces

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
G

Guest

Thanks for the help, everyone. It works.

Ron Coderre said:
Try this:

For text in A1

B1: =SUBSTITUTE(A1," ","")
Removes ALL spaces

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove a space infront of text in a cell? 7
How do I remove extra space when text wrapping? 2
How do you remove trailing spaces withour Trim function? 8
Splitting cell contents into other columns 1
Remove Spaces After Number 2
Removing leading and trailing space... 2
Formatting Problems 2
Removing blank spaces from the ends of email fields? 2

Top