I have a scenario where I use OCR to extract data from a PDF file into a results excel file. I have to manipulate two of the columns of data as detailed below. What is the best practice to achieve this?
Create a new column based on a value in column A based on data from a separate excel file. For example, if cell A1 has a value “Red” the system would need to look for the value in a separate excel file and enter the value found “100” as an example.
Add (-) and (0) in between characters in column B. For example, cell B1 has a value of 777888999. I need to manipulate this value to read 777-888-999-00.
Any suggestions to achieve this would be greatly appreciated.