How do you remove excess spaces from an Excel field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 9000+ fields that have excess spaces at the front of each figure.
I have tried to use the TRIM function but have not met with teh desired
result.
Is there an easy/quick way of removing the excess spaces?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you remove excess decimal places in Excel? 4
Removing excess spaces in data 7
Deleting excess rows from a spreadsheet 1
Excess white space in chart 1
Conditional formula in Excel 3
How do you remove trailing spaces withour Trim function? 8
Removing blank spaces from the ends of email fields? 2
Clear excess formats in Excel 2007 3

Back
Top