Getting Plain Text into Excel Columns
Fellow Forum Members,
I work a lot with Engineering Drawings done in AutoCad and ouputted as a PDF file. I often need to grab the text in the Bill of Material (BOM) table as TAB delimited text.
Using Adobe Acrobat I'm able to select the 4 columns of data and paste it into and app like NOTEPAD or WORD.
However, the text once pasted into NOTEPAD or WORD is not TAB DELIMITED and not in columns and therefore not possible to paste into columns inside an Excel worksheet.
What is the correct way to prepare plain text data into columns so that it could be pasted into Excel columns? Any info will be greatly appreciated. Thank
|