Converting calculated value to text

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I am a limited Excel user. My project is to take an all caps
comma-delimited file and turn it into an organization's printed
directory. I've used PROPER to get the case changed, CONCATENATE to
combine the street number and street name, and had to parse out the
phone number (which came to me as 8882221234 format) using LEFT, MID,
RIGHT so I can get dashes between the segments (888-222-1234). All is
well so far. I will then go to Word format the fields and have a
lovely booklet.

My big problem is that now I have too many columns/fields. I want to
convert these new fields to a text value and get rid of the original
fields. Can I do it? What command? (Yes, of course I have preserved
the original data.) I don't want to just hide the columns.
 
Why not format it in Excel and print it from there, instead of exporting it
to Word?
 
Lee

Select your range with the formulas and Copy>Paste Special(in place)>Values.

You can now delete the originals.

Gord Dibben Excel MVP

 
Back
Top