I have the following cell content: C $67.99 (there is a whole column of this type of content, approximately 300 items)
This cell is General formatted and its contents are left aligned in Excel.
How does one strip the C, the space after the C and the $? (The C denotes Canadian $)
I need to be left with a number which I can then include in a sum
This action then needs to be performed on all the items in the same column
PS - I obtain the initial data from eBay in .csv format. I download the file, open it as .csv in Excel and then save it as a workbook. I re-open the workbook and proceed from there.
Any help would be appreciated. I've chased after eBay inquiring why this data is in this format-no response.
This cell is General formatted and its contents are left aligned in Excel.
How does one strip the C, the space after the C and the $? (The C denotes Canadian $)
I need to be left with a number which I can then include in a sum
This action then needs to be performed on all the items in the same column
PS - I obtain the initial data from eBay in .csv format. I download the file, open it as .csv in Excel and then save it as a workbook. I re-open the workbook and proceed from there.
Any help would be appreciated. I've chased after eBay inquiring why this data is in this format-no response.