Hi dn,
To remove all spaces in a text string in
Excel 2003, you can use the
SUBSTITUTE function. Here are the steps:
- Select the cell where you want to remove the spaces.
- Type the following formula in the formula bar:
Code:
=SUBSTITUTE(A1," ","")
- Press Enter.
This formula will replace all spaces in the text string with no space. You can then copy and paste the formula to other cells if you need to remove spaces from multiple text strings.