Hi Mike,

Dave Peterson gave an excellent answer yesterday to a question very similar
to the one you have asked.

Hope this helps.

Best regards,
Kevin

You may want to take a look at David McRitchie's TrimAll macro:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

David also has instructions on how to install a macro and run it at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Les wrote:

I have a csv file that I would like to import to a
waiting worksheet with formulas already in it. I have 2
problems, the figures are not recognised as numerical
when using the sum if function and the csv file is not in
the fomat I would like. If I could attach the file I
could show you, can anyone help?
--

Dave Peterson


"Mike Molyneaux" wrote in message
...
I'm using Excel 2000 & nt4, sp6

I'm importing a print file that has some special
characters in various fields. How can I remove them?

sample:
field
GREG SMITH

Need code to replace the 'tab' with a space.

GREG SMITH


Thanks Mike

thanks - worked great