"cochranrg" wrote in message
...
I'll try this. I did the MID thing, but this doesn't work for what I am
trying to do (once I delete the original column of text of course my
formula
doesn't work any more). What I'm doing is converting a tab deliminated
file
to a csv file for internet upload. The csv file needs to be truncated to
characters per column.

Rob


Select the results of your formulas and copy.
Without changing the selected area, use
Edit Paste Special Values
This replaces the formulas with their results.
You can then delete the original data.