de-concatenate

  • Thread starter Thread starter BK
  • Start date Start date
B

BK

Any help appreciated. I have a column of cells containing equity tickers as
follows:

T US Equity
AC FP Equity
DTE GR Equity

How can I use a formula to remove the "Equity" text from the cel e.g. so
that I have a list of cells:

T US
AC FP
DTE GR

Thanks in advance
 
Hi

You could just use Find/Replace. In the 'Find' box type Equity and leave
the 'Replace With' box blank
 
Baruch,

=SUBSTITUTE(A1," Equity","")
Copy down to match your data.

Or simply use Find/Replace and replace " Equity" (a space followed by
Equity, without the quotes) with nothing.

HTH,
Bernie
MS Excel MVP
 
Back
Top