formula required

  • Thread starter Thread starter Vicky
  • Start date Start date
V

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
 
Vicky said:
In Cell B1 i need the answer, abcdef200912070005643
Click to expand...

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 -----
 
Paste the below formula in B1 cell
=LEFT(A1,FIND("<",A1)-1)

Remember to Click Yes, if this post helps!
 
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
 
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!
 
It works... thanks a lot!!!!!
Vicky

Ms-Exl-Learner said:
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!
Click to expand...
 
Back
Top