Thread
:
formula containing text
View Single Post
#
2
Posted to microsoft.public.excel.misc
Pete_UK
Posts: n/a
formula containing text
Try this formula in C1:
=VALUE(RIGHT(A1,LEN(A1)-FIND("$",A1))) * B1
Format as currency with 2 dp and copy down as necessary. Assumes you
will always have a $ before the numbers.
Hope this helps.
Pete
Reply With Quote