Hello:
I have H106=BI622
I need a formula to extract 622 of the above.
Let me Know if you have any questions.
Thanks.
Riz
Hello:
I have H106=BI622
I need a formula to extract 622 of the above.
Let me Know if you have any questions.
Thanks.
Riz
are those cell refs?
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
Hi FDibbins:
Yes they are cell reference.
Thanks
Riz
=RIGHT(A1,3) if that was in cell A1, but as Ford suggested, those look like cell references. Are you saying that in cell H106 you have the formula "=BI622"? If the above, ie. H106=BI622, is the data in a single cell then what is the syntax of the data? Are the last 3 characters always numbers? If not is there always 2 letters after the =? We need more detail than you have provided.
so in cell H106 you have a reference to BI622?
Off hand, I cannot think of any function that will pull the row number from a formula like that.
Perhaps if you explained what you are trying to do?
Assuming that the string is in A1, try this array formula which requires confirmation with Ctrl+Shift+Enter
Does this help?Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Try this one
=REPLACE(A1,1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")-1),"")
A B 1BI622 622
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi Alkey:
It gives the same result.....BI622
Riz
Hi,
Can you please confirm what the actual cell contents are?
Is it:
B1622
or actually a formula:
=B1622
Regards
Did you try the formula suggested in post#6? If A1 is H106=BI622, the formula will return 622 as per your requirement. Is this not you are looking for?
If cell A1 contains this string:
BI622
Then this formula will return the row number:
=ROW(INDIRECT(A1))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Or, if A1 contains the string:
H106=BI622
This formula will return the row number of the right cell address:
=ROW(INDIRECT(MID(A1,FIND("=",A1)+1,20)))
Hello Tony:
Your solution #12 works great.
That's what I wanted, thxs..
Riz
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks