Excel formula

  • Thread starter Thread starter zachtom
  • Start date Start date
Z

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