Hello Excel gurus,
My question today relates to extracting some key information from cells. Unfortunately the text-to-columns tool in Excel does not work for me as I would like to see the extracted information in a specific format/layout. I've tried using it but the data does not get extracted very cleanly.
My guess is that this will require left/mid/right, however the issue I'm running into is there are certain symbols like "$" or "(" in the raw data which are not unique in one text string so these formulas are not working for me. I've also tried using find/search but still running into a road block. I've attached a sample of the worksheet and outlined the raw data as it currently is and the extraction/result I would like to see. This raw data is in essence a financial report that I receive from the company system and the numbers are changing all the time.
Any help would be appreciated as always.
Thanking you all in advance.
Bookmarks