View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default 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