ExcelBanter - formula required

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula required (https://www.excelbanter.com/excel-discussion-misc-queries/250527-formula-required.html)

vicky

formula required

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[_2_]

formula required

"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

Ms-Exl-Learner

formula required

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

vicky

formula required

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

Ms-Exl-Learner

formula required

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

T. Valko

formula required

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

vicky

formula required

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

Ms-Exl-Learner

formula required

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

All times are GMT +1. The time now is 09:53 PM.