if you simply take the C off of the front of the line you can convert it to a number or currency. if it is always "C $" and you only want the numbers left you could use the following in B1.
=RIGHT(A1,LEN(A1)-3)+0
This will take off the "C $". if you change it to =RIGHT(A1,LEN(A1)-1)+0 It will just take off the "C" and should still convert to currency.
How this works, it takes the right x amount of characters from the string in A1. x is figured by the entire length of the string in A1 - 3 or 1 in the examples above.
the +0 at the end takes the string of now numbers and adds a number to it, thus converting the string to a number format.
Hope this helps you.
Bookmarks