Try this...

=SUBSTITUTE(A1,"<ready","")

Note that this is case sensitive.

--
Biff
Microsoft Excel MVP


"Vicky" wrote in message
...
oh, sorry i didn't mention exact requirement.

I need the answer like this
abcdef200912070005643,abcdef200912070005644,abcdef 200912070005645,

sorry once again for not giving the exact information.

Please help me on this.

Vicky

"Ms-Exl-Learner" wrote:

Paste the below formula in B1 cell
=LEFT(A1,FIND("<",A1)-1)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Vicky" wrote:

Hi,

Cell A1 has the information.

abcdef200912070005643<ready,abcdef200912070005644 <ready,abcdef200912070005645<ready

In Cell B1 i need the answer, abcdef200912070005643

Thanks in Advance!!!!

Vicky