Formating? ##### instead of text in cell

[mljohn]

In an Excel spread sheet sent to me some of the cells show this:

###############################################################################################################################################################################################################################################################

When I click on the cell it shows this:

C120, C120F, C122, C122F

With a lot of spaces after it.

If I delete the spaces manually then it reads proper.

How do I get rid of all the spaces?

Thanks

 

[gsistek]

What is the range of cells you need changed?

 

[T. Valko]

In an Excel spread sheet sent to me some of the cells show this:

##########.....

When I click on the cell it shows this:

C120, C120F, C122, C122F

With a lot of spaces after it.

If I delete the spaces manually then it reads proper.

How do I get rid of all the spaces?

Thanks

The macro at this website will remove all leading/trailing and multiple interspersed char 32 space characters. It will also remove and/or convert char 160 non breaking spaces into standard char 32 space characters. It will work on text or numbers and the numbers will be converted to true numeric numbers.

I use this macro dozens of times every single day! It is a real time saver.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[mljohn]

Wow! That was cool. Thanks for the link.

Matt

 

[T. Valko]

Wow! That was cool. Thanks for the link.

Matt

You're welcome. Thanks for the feedback!