Hi Folks, -- I am pulling my hair out. I have an excel file that has the following in a cell:
I need to extract these values surrounding the tilde (~). Does anybody have any bright ideas? I really don't want to go through 8000 lines of spreadsheet.
I am using Excel 2010