Hello All,
This is my first post here and looking for help.
I am working with a database which does not let me import data. So i have taken screen shots of the data, cropped the relevant data needed using MS paint and pasted the images on a word document.Next converted the word Doc into PDF and then using a OCR, have converted the images to editable text. Next have copied the converted text into excel.
Now I need help formatting the data. Have succeeded in separating the single column into multiple columns using the de-limited format and removed the parenthesis using replace function
Need help on the following
1) Converting the multiple rows of data in each paragraph in MS word into a single column
2) Pasting the different paragraphs in the word document into different columns.
Any and all help will be much appreciated. Am attaching the files for clarification.
Thank you very much
Suresh
Bookmarks