quote 6 out of 12 fields

  • Thread starter Thread starter carlos.ohiggins
  • Start date Start date
C

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
 
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
 
Back
Top