| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula required | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Formula Help required | Excel Discussion (Misc queries) | |||
| FORMULA REQUIRED | Excel Discussion (Misc queries) | |||
| Help Required With IF AND Formula | Excel Worksheet Functions | |||
Hybrid Mode
