How to Arrange telephone directory ocr image in excel, in table form

[asad75]

I am posting two files 'textfilefromocr.doc' is the form of data I got from OCR, then I copy paste that data into excel worksheet named 'rawdata' and created another worksheet named 'requiredform'well that is the eventual form, from there I would export that tabular form as it is, to ms-word
Any swift way to do this thing kindly suggest I am waiting..

ANY OTHER WAY ALSO

[asad75]

kindly anyone help...........

[ashleyuk1984]

The data is just a complete mess.
I would suggest trying to find another way of importing your data first.

[D_Marcel]

The code to organize this would need several "Ifs" to identify and treat all situations here:


1. Name and address in the same cell;
2. Phone beside the Address, below the name;
3. Name, Address and Phone in the same cell;
4. Indexes with phone;
5. Phones in the cells beside (you may use the method 'variableaname.offset(x,y).value' here.
.
.
.

Check if the feature 'Text to Columns' in tab 'Data' can help you somehow.