"Vicky" wrote:
In Cell B1 i need the answer, abcdef200912070005643

So, type abcdef200912070005643 into B1 and press Enter.

Okay, that's probably not the answer you were looking for ;-). But the
point is: you don't say much to tell us what kind of answer you are looking
for.

If you want the first 21 characters, then: =LEFT(A1,21)

If instead you want any number of characters to the left of the first
"<ready" then:

=LEFT(A1, FIND("<ready",A1)-1)

If instead you want....

Well, you get the point. If neither of those solutions are what you want,
explain the problem better.


----- original message -----

"Vicky" wrote in message
...
Hi,

Cell A1 has the information.

abcdef200912070005643<ready,abcdef200912070005644 <ready,abcdef200912070005645<ready

In Cell B1 i need the answer, abcdef200912070005643

Thanks in Advance!!!!

Vicky