Ending spaces need to be removed

  • Thread starter Thread starter mjwillyone
  • Start date Start date
M

mjwillyone

Friends,

I have exported an SQL database table to a text file and need to d
some work on it in Excel. Each field is comma-delimited. However, th
table must have used fixed field lengths because the data now has blan
spaces at the end of every field. I want to remove the extra spaces.
I would like to enter a formula in a nearby cell that will do this.
can then use the Paste-Special option to copy only the values rathe
than the formulas.

Anyone know how to do this?

Thanks,
Mik
 
the eazyest way to work in Excel with ant DB data is to
use ASAP-Utilities(.com). Its all in that package. It'll
take you 15 min to get used to it but then you are good
to go
 

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

Revome blank spacing from ending Numbers 6
leading and ending space 2
Vlookyp fails due to space at the end 2
how to remove spacing in between text 6
Removing spaces at the end of numbers 5
How to remove space from a cell. 15
Data cleanup 1
Access Access anti-trim?? 0

Back
Top