Convert rows to columns

L

lucrezia

Hi all,

I have a list made up of mailing labels which I have scanned into
Acrobat and used to OCR function to make usable text.I have then cut
and paste this list into Excel. The problem now is that once brought
into Excel I have one column with all the names and addresses. I need
to move these entries into separate columns. Name, addres, city etc.
There are no spaces between any of teh rows at this point. Also, some
entries have 3 rows of data, some 4, some 5.

Is there any way to have Excel move the data to different columns when
the entries are varied like this???

Thanks in advance for the help.

Mary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Need Help with a VBA subroutine 0
Create a list of unique entries based on several columns 1
Duplicate entry in a column/row 14
Need formulas for searching for a value in a table and returning row/column name 7
calculate last 4 data points in a column (with sometimes blank rows) 7
Mailing address block: sorting 1 row to columns 1
sorting noncontiguous data with exceptions 3

Top