Mega formula

[Rachel Curran]

Help,

I have the following 4 formulas in the same worksheet. Can you please
show me how I can put them all in the same formula rather than 4
separate ones?

=FIND(" ",A2153,1) - in B2153
=LEFT(A2153,B2153) - in cell C2153
=FIND("]",A2153,1) - in cell D2153
=RIGHT(A2153,D2153-B2153) in cell E2153

They are all looking at cell A2153 which currently contains :B704 [AIR
VEHICLE]

Thanks

 

[Michael J. Malinsky]

If your desired result is [AIR VEHICLE] then this will work:

=RIGHT(A2153,LEN(A2153)-FIND(" ",A2153))

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[Frank Kabel]

Hi Rachel
try
1. Formula:
=RIGHT(A2153,FIND("]",A2153,1)-FIND(" ",A2153,1))

2. Formula
=LEFT(A2153,FIND(" ",A2153,1))