Link to home
Create AccountLog in
Avatar of Ladkisson
LadkissonFlag for United States of America

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!
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

Do they all have a ")" immediately before the amount?

If so, you can use a formula such as this:

=RIGHT(A1,LEN(A1)-FIND(")",A1))
Avatar of Ladkisson

ASKER

it did not work...another example:

Comprehensive Profile350.00 ... I need $350 only or

BLOOD Type ABO20.00.... I need $20.00 only
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Sorry, my Excel is acting buggy for some reason and I can't properly test what I want to at the moment.
Truly the Best! Thank you!
You can try to use this formula:

=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)

Open in new window


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))

Open in new window