LinkBack URL
About LinkBacks
hello
i have data in cell F1 Like "OLPTBC+J+JT150.50"
i want to extract as below
G1 = OL (always first two words only)
H1 = PT (always third and forth words only)
I1 = BC+J+JT (rest of all words)
J1 = 150.50 (Only All numbers)
thanx a lot
hello
i have data in cell F1 Like "OLPTBC+J+JT150.50"
i want to extract as below
G1 = OL (always first two words only)
H1 = PT (always third and forth words only)
I1 = BC+J+JT (rest of all words)
J1 = 150.50 (Only All numbers)
thanx a lot
G1Formula:
Please Login or Register to view this content.
H1Formula:Please Login or Register to view this content.
i1Formula:Please Login or Register to view this content.
J1Formula:Please Login or Register to view this content.
Essentially all that Min formula is doing is finding the position of first number
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
if your data remains in same way for all the cells then in
g1 copy paste below then hold control and shift and then hit enter
=IF(COLUMNS($G$1:G1)<3,MID($F$1,((COLUMN(A1)-1)*2)+1,2),MID($F$1,5,MATCH(TRUE,ISNUMBER(MID($F$1,ROW(INDIRECT("1:"&LEN($F$1))),1)+0),0)-1-4))
drag till column I
In J1 copy paste below then hold control and shift then hit enter
=RIGHT(F1,LEN(F1)-SUM(LEN(G1:I1)))+0
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Use below formulas (another method for extracting I1 and J1 strings) :
In G1 :In H1 :Formula:Please Login or Register to view this content.In I1Formula:Please Login or Register to view this content.In J1Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Last edited by Saarang84; 05-13-2014 at 03:47 AM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Hi Hemesh,Originally Posted by hemesh
Your formulas doesn't seem to work... Can you please check it?
Have you confirmed it as array.
Yes, I tried as per your instructions, it doesn't work.
Find attached.
HELLO humdingaling
Amazing works perfect
thanx a lot
will add u reputation
Hello hemesh
thanx u too
ur method is working also
You are welcome Thanks for the feedback Haroon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks