Import from Access - multiline address field to be parsed

[mjwillyone]

Hello,

I exported a table from MS Access 2007 to Excel. In Excel, I would like a way to transpose all multi-line addresses in the address1 column into other columns. A 3-line address will take up 3 columns, a 4-line will take up 4. Is there a way to do this?

I have attached a file that I think will help.

Thank you,
Mike

Addresses from Access 2007.zip

[Kenneth Hobson]

With the cells selected, run this:

Please Login or Register  to view this content.

[AB33]

Another option attached.

[Kyle123]

Or without vba, substitute the line breaks (char(10)) with another character and do text to columns

[mjwillyone]

That code, Kenneth, worked perfectly! Thank you so much!!

Mike