What i am actually trying to do is to extract numbers and texts in different cells e.g A1 contains <LGGACC=29720KG; LGGLOS=56105KG; LGGADD=4356KG> and want to get <LGGACC>, <LGGLOS> & <LGGADD> in cell B1,B2 & B3 respectively; while, <29720>, <56105> & <4356>in cell C1, C2 and C3 respectively.
i will be happy if it is formula than VBA
Hi and welcome to the forum
Not sure I entirely understand your examples, but maybe try this...
=left(A1,find("=",A1,1)-1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
welcome to the forum, nuruedriss. it's always better to upload a sample excel file with a few examples so we can see a pattern. it's also hard to tell if you want those brackets <>, or are you just simply illustrating those in the brackets belong to a cell. if it's the latter, try this for B1:
Formula:
Please Login or Register to view this content.
and for C1:
Formula:Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
@ Ben I *think* each 1 of those is in its own cell (could be wrong though lol)
@FDibbins:
haha. my guess is he wants something like this.
A B C 1 lggacc=29720kg; lgglos=56105kg; lggadd=4356kg lggacc 29720 2 lgglos 56105 3 lggadd 4356
@nuruedriss:
see how you make us guess without a sample file showing desired answers?
Last edited by benishiryo; 09-30-2013 at 10:54 AM.
Guess we will just have to wait and see. I like your formula though (try saying that 5 times quickly though LOL)
Sorry for making u guess around. That is exactly what I want. When I was trying to upload my excel it opens another window which is loading and non responsive what shall I do… advance thanks for all of u.Originally Posted by benishiryo
@FDibbins:
haha. my guess is he wants something like this.
A B C 1 lggacc=29720kg; lgglos=56105kg; lggadd=4356kg lggacc 29720 2 lgglos 56105 3 lggadd 4356
@nuruedriss:
see how you make us guess without a sample file showing desired answers?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks