Youre welcome and thanks for feeding back!!!

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


"Vicky" wrote:

It works... thanks a lot!!!!!
Vicky

"Ms-Exl-Learner" wrote:

This will get you the result you have asked for
=SUBSTITUTE(SUBSTITUTE(A1,",",""),"<ready",",")
abcdef200912070005643,abcdef200912070005644,abcdef 200912070005645,

This is will also get the same result but in the end you will NOT get the ,
(comma) in the below
=SUBSTITUTE(A1,"<ready","")
abcdef200912070005643,abcdef200912070005644,abcdef 200912070005645

So use the First formula for your requirement.

Remember to Click Yes, if this post helps!

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


"Vicky" wrote:

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