I would like to parse a cell column of strings in Excel VBA, each of the cell contains the following:
2 '␂'
I would like to change the contents of this cell to contain only 2 (or any numeric characters just before the 'string'. What would be the easiest method of parsing such info? Thanks.