Excel formula

[zachtom]

I have downloaded data from my manufacturing system in a tab-delimited
format. I import into excel and some of the data in some of the
columns have quotation marks around my text. What formula can I write
to detect whether there is a quotation mark at the begining or end of
my column and if there is, delete the mark. Bear in mind that the data
is different lengths.

Thanks

 

[Jim]

Select the data and Edit>Replace>~?>Replace With>*leave blank*>Replace
All>OK.
The tilde (~) is located to the left of the number 1 on the PC keyboard. You
may also use ~* to find/replace the * symbol.