Removing spaces in numerous cells

  • Thread starter Thread starter marti
  • Start date Start date
M

marti

I have a couple hundred rows of data where I need to change the format.
The format right now is one of these:
"01 01"; "01 02"; "01 03" or
"03AAP"; "03A02"; "03DDP"
I need them to look like this:
"0101"; "0102"; "0103" or
"03AP"; "0302"; "03DP"

Any recommendations? I use Excel 2003
 
Just do a simple replace.

Highlight the rows you want affected.
Click Edit
Click Find and select the Replace tab
In the Find What slot hit the space bar once
In the Replace with slot, do nothing

Select Replace All
 
If all that data is in a single column, then I'd insert a column directly to the
right of it and use a formula like:

=left(a1,2)&right(a1,2)
And drag down.

This should work if all your strings are 5 characters.
 
Back
Top