Ending spaces need to be removed

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
 
G

Guest

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

Spaces not being recognized be excel as spaces!! Help! 4
Adding Spaces to the end of a value 4
Alter Table pads spaces to 255 characters 5
Why does TransferText trim when importing string 7
Programming to delet padded spaces 4
numbers need to be numbers 4
adding empty spaces to fields? 10
Unwanted trailing spaces in form 5

Top