removing spaces

  • Thread starter Thread starter kcm
  • Start date Start date
K

kcm

I need to remove the space from the text within a cell.

The column is about 9500 rows long so do I use the find and replace
tool.
 
can you give us an example of the text and where the space(s) are tha
need to be removed
 
B MM1595328696
this is the data within a cell it is a product number.
I need to remove the space between the B and MM.

I have about 9500 of these product numbers all need the space removed.

Thanks
 
First, select the range of cells you want to work with

Then: Edit>Replace
Find what: hit the [space bar]
Replace with: Make sure there's nothing in here
Click [Replace All]

Caveat: Doing that will replace ALL spaces in the selected range, so i
you only want some of the spaces in each cell removed, post back to ge
a different solution.

Does that help?

Ro
 
Back
Top