remove blanks from a string of chars within a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
All the blanks?

=SUBSTITUTE(A1," ","")

Lots of cells and permanently - Select range and use Edit / Replace,
replacing space with nothing.
 
Hi Ray,
When posting please include the question in the text body.

Not everything that appears to be a space is a space, frequently
when copying from HTML you will copy a non-breaking space
character ( ) or char(160) also known as a required blank (RBL)
in some places.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
 
You must log in or register to reply here.

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 to make a number have a certain number of characters. 5
cell lenght MUST be always 30 8
How to determine char or number? 4
How to count the number of occurrence within string? 2
Text - Remove text Item No.99 (First 2 Chars) and move to end 5
How to change color within string? 2
Char(10) and blank lines 6
limit # of chars in a cell 1

Back
Top