Share via

remove space from numbers

Anonymous
2012-03-22T07:22:46+00:00

I need to remove space from barcode numbers in Excel. The numbers are formatted like "123_456_789_" where the underscore denotes a space. I want to convert this number to "123456789". Any assistance would be greatly appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-03-22T07:55:47+00:00

I need to remove space from barcode numbers in Excel. The numbers are formatted like "123_456_789_" where the underscore denotes a space. I want to convert this number to "123456789". Any assistance would be greatly appreciated.

If you want the string "123456789", try this formula:

=SUBSTITUTE(A1," ","")

If you want the number 123456789, try this formula:

=0+SUBSTITUTE(A1," ","")

Make sure that you don't have any number formatting in the cell that will displays numbers with blanks as thousands separators.

Hope this helps / Lars-Åke

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest