asked on To separate text from value in excel
Hello!
I am pulling data from online and pasting it into excel. It is a text with a $$ amount. Is there a formula that will separate description from $$?
Example A1= CULTURE BLOOD (Base Charge)130.00
I need B1 = $130.00
Thanks!
I am pulling data from online and pasting it into excel. It is a text with a $$ amount. Is there a formula that will separate description from $$?
Example A1= CULTURE BLOOD (Base Charge)130.00
I need B1 = $130.00
Thanks!
Microsoft Excel
Last Comment
Rodney Endriga
ASKER
it did not work...another example:
Comprehensive Profile350.00 ... I need $350 only or
BLOOD Type ABO20.00.... I need $20.00 only
Comprehensive Profile350.00 ... I need $350 only or
BLOOD Type ABO20.00.... I need $20.00 only
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Sorry, my Excel is acting buggy for some reason and I can't properly test what I want to at the moment.
ASKER
Truly the Best! Thank you!
You can try to use this formula:
It finds the first number value in the string.
This will insert the '$' in the result:
=RIGHT(A1,LEN(A1)-MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&{0;1;2;3;4;5;6;7;8;9}))+1)
It finds the first number value in the string.
This will insert the '$' in the result:
=DOLLAR(RIGHT(A1,LEN(A1)-MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&{0;1;2;3;4;5;6;7;8;9}))+1))
If so, you can use a formula such as this:
=RIGHT(A1,LEN(A1)-FIND(")"