changing cell values with text and currency

G

Guest

Hi, I need to add some cells together but they have both text and currency.
example "$30.00 USD" is there anyway to add them with both text and currency.
Or anyway to format them to delete the text portion. As it takes me a long
time to delete the text hand. Cheers and thanks Leah
 
G

Guest

You can transform text "$30.00 USD" to number 30.00 with this formula in a
new column, say enter in B1
=SUBSTITUTE(SUBSTITUTE(A1,"$","")," USD","")
Then you can sum column B.

Regards,
Stefi


„Leah.girl†ezt írta:
 

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

filter on currency number format 3
Macro that will insert a simple text string in top cell of text file 1
To get a sum for variant currency values 3
Custom Number Format Text 3
How to add currency symbol to a cell value 3
Identifying currencies 7
convert to text problem 2
Format cell - Miles 5

Top