Ladkisson

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!

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

membership

Create an account to see this answer

Signing up is free. No credit card required.

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