extract covert dollar value in text cell to just dollar value

  • Thread starter Thread starter Guest
  • Start date Start date
for Cell A1 use

=MID(C29,FIND("$",A1),72)

this will extract everything to the right of (and including) the $ sign
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text and Dollar Value 3
Assigning Dollar Values to 'Buckets' 5
Need Help Creating a Macro to Multiply Cells by a Constant Number 5
formulas dollars and formula % 7
Is there a formula to change number to word. Ex. $10 > ten dollar 2
Assigning Bin to Value 2
Displaying results in dollars 3
How do I combine dollars and text 5

Back
Top