de-concatenate

[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

 

[Andy B]

Hi

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

 

[Bernie Deitrick]

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