formula required

[Vicky]

Hi,

Cell A1 has the information.

abcdef200912070005643<ready>,abcdef200912070005644<ready>,abcdef200912070005645<ready>

In Cell B1 i need the answer, abcdef200912070005643

Thanks in Advance!!!!

Vicky

 

[Joe User]

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 -----

 

[Ms-Exl-Learner]

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

Remember to Click Yes, if this post helps!

 

[Vicky]

oh, sorry i didn't mention exact requirement.

I need the answer like this
abcdef200912070005643,abcdef200912070005644,abcdef200912070005645,

sorry once again for not giving the exact information.

Please help me on this.

Vicky

 

[Ms-Exl-Learner]

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

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,abcdef200912070005645

So use the First formula for your requirement.

Remember to Click Yes, if this post helps!

 

[T. Valko]

Try this...

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

Note that this is case sensitive.

 

[Vicky]

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

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

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,abcdef200912070005645

So use the First formula for your requirement.

Remember to Click Yes, if this post helps!

 

[Ms-Exl-Learner]

You’re welcome and thanks for feeding back!!!