Remove Spaces

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I recently switched from Excel 2003 to Excel 2010.

I am trying to remove spaces in a cell.

I think I use to use the find/replace in 2003 to do this but it does
not seem to work in 2010.

Here's an example of some data I am trying to remove spaces from.

CVGXBSC
CVGXC411
CVGXCMPS
CVGXCSS
CVGXDBK
CVGXFMT
CVGXLEH
CVGXLQP
CVGXMER

Thank you in advance for your assistance.
 
I recently switched from Excel 2003 to Excel 2010.

I am trying to remove spaces in a cell.

I think I use to use the find/replace in 2003 to do this but it does
not seem to work in 2010.

Here's an example of some data I am trying to remove spaces from.

CVGXBSC
CVGXC411
CVGXCMPS
CVGXCSS
CVGXDBK
CVGXFMT
CVGXLEH
CVGXLQP
CVGXMER

Thank you in advance for your assistance.
Click to expand...

Edit>replace
use "~ " (tilde space - no quotes
 
Back
Top