J
John13
If I cut and paste this (see below) from an email body to Excel and do
a Text to Columns, I can't remove the blank spaces before and after
each of the three columns. I have tried =TRIM(cell) and =CLEAN(cell)
but to no avail. I made sure the columns were in the Text format.
This is just a small sample, otherwise I would retype it. I tried
Paste Special and tried all the optional pasting types. I am missing
something, so could someone point me in the right direction? Thank
you.
Jones Foley, AL 12/18/07
Smith Harriman,NY 1/15/08
Thomas Secaucus, NJ 1/15/08
John13
a Text to Columns, I can't remove the blank spaces before and after
each of the three columns. I have tried =TRIM(cell) and =CLEAN(cell)
but to no avail. I made sure the columns were in the Text format.
This is just a small sample, otherwise I would retype it. I tried
Paste Special and tried all the optional pasting types. I am missing
something, so could someone point me in the right direction? Thank
you.
Jones Foley, AL 12/18/07
Smith Harriman,NY 1/15/08
Thomas Secaucus, NJ 1/15/08
John13