Hi, could you pls help me with the formula to extract either 61% or 61 from cell A1? thanks.
Hi, could you pls help me with the formula to extract either 61% or 61 from cell A1? thanks.
Try this:
=MID(A1,FIND("</",A1)-3,3)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This might work also:
Formula:Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Try this
Enter in B1
Format cell B1 as percentage.
Formula:Please Login or Register to view this content.
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
Thanks to both of you. May I trouble you again to extract 13.8 from the string below?
<b>13,8 CNY</b>
For this you would need a different formula
Assuming that short string is in A2
Formula:Please Login or Register to view this content.
Thanks Alkey. Sometimes it is not CNY but some other currency. It is possible to have a generic formula that extracts the numbers only and converts the commas to "."?
Formula:Please Login or Register to view this content.
Thanks so much. It works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks