changing cell values with text and currency
 

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

changing cell values with text and currency
 

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:

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