Exclude a word

[Lartk]

Is there a way to get rid of the word "equity" in the below.

In cell A1, i have this: JPM US Equity

In cell B1, i would like to say = cell A1 - equity) - so the result would just be JPM US

Is that possible to write in a VBA code?

[Lartk]

But I cant use the =right or left function because in each case the number of characters before the word equity differs..

[GarysStudent]

How about:

Sub dural()
Range("B1").Value = Replace(Range("A1").Value, "equity", "")
End Sub

[p45cal]

in b1:
=SUBSTITUTE(A1,"equity","")
you could also wrap it in TRIM:
=TRIM(SUBSTITUTE(A1,"equity",""))

[snb]

You won't need VBA; use ctrl-H