LEFT and RIGHT functions

I know it is possible to use the LEFT and RIGHT function to select text that is a number of digits away from the left or right but is it possible to do this to the first < charachther from the left and the first > from the right.

ie

i have a piece of text like this in a cell A3

TEXT TEXTEXXAMPLELEFT<NL>EXAMPLE TEXT RIGHTTEST TEST

in cell A1 I want everything on the left of the <NL>
in cell B1 I want everything to the right of the <NL>

and i would like to do it without the text import wizard as i need this text to stay in A3 aswell.

thanks

Shane

Use:
=LEFT(A1,FIND("<nl>",A1)-1)
and
=RIGHT(A1,LEN(A1)-(FIND("<nl>",A1)-1)-4)

A1 contains your text. 4 in the formula represents the length of the seperator, in this case it is <NL> which has 4 characters.

- Mangesh

brilliant that thanks very much for the speedy reply