quote 6 out of 12 fields

[carlos.ohiggins]

Hello excellers,

I need to use excel to read in a 12 field semi-colon separated file
with a few 100 colums.
No problems there,but having read it in I want to put single quotes
round 6 of the 12 fields.
Any assistance with that would be very helpful indeed!

Best Regards

Tony

 

[Gary''s Student]

Say we want to surround column B values with single quotes.

In an un-used cell, say Z100, enter:
''
this is TWO single quotes, not a double quote.

In an un-used column enter:

=$Z$100 & B1 & $Z$100
and copy down