Good day,
I have the following text string in one cell:
Delivery .05 % or $ .00 per mile, or 7 % or $0 per pound
I need to extract the numbers from the string. Is there a formula or a code I can use for this? I would like to have the numbers on separate columns if possible.
Thanks!!!
Give this one a try
Enter formula in B1 and drag formula across to cell E1. Format cells B1 and D1 as percentage.
Formula:
Please Login or Register to view this content.
v A B C D E 1 Delivery .05 % or $ .00 per mile, or 7 % or $0 per pound 0.05% 0 7% 0
Last edited by AlKey; 10-30-2018 at 10:53 AM.
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
Please try
=--MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"Delivery",REPT(" ",90)),"per mile, or",REPT(" ",90)),"or $",REPT(" ",90)),"per",REPT(" ",90)),90*COLUMNS($B1:B1),90)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks