18 Feb How to extract values from a column that contains currency symbols

1.Open the file using Character set UTF-8 (see setting UTF-8)

2.In the next empty column (in the example column C):

2.1. set the header to, e. g. ‘Value’

2.2. set the formula for each row to =MID(B2,3, LEN(B2)), where B is the column that contains the value to be extracted

Drag the formula down the column(C) for all rows in the file

3.In the next empty column (in the example column D):

2.1. set the header to, e. g. ‘ValueNumeric’

2.2. set the formula for each row to =VALUE(C2), where C is the column that was extracted

Drag the formula down the column(C) for all rows in the file

The Values in Column D are now numerical and calculations can be performed on them.