Text delimited by a "soft" return?

[anewc1]

Excel Workbook
	D
1	address
2	*
3	209 S Grove #202Ypsilanti, MI *48198
4	27117 FlorenceInkster, MI *48141
5	10612 E. JeffersonDetroit, MI *48214
6	20105 KensingtonTaylor, MI *48180
7	19917 Woodbine StDetroit, MI *48219
8	1366 AndreaYpsilanti, MI *48197
9	31510 Concord Drive, Apt AMadison Heights, MI *48071
10	655 Timberlane StreetYpsilanti, MI *48197
MP_EmployeeYTDInfo

How do I separate the two lines of data in this list? They appear to be delimited by a soft return. When I try to use text to columns and use tab as the delimitor, the second line completely disappears. My ultimate goal is for the list to look like this:

Excel Workbook
	A	B
2	address	City, State, Zip
3	209 S Grove #202	Ypsilanti, MI *48198
4	27117 Florence	Ypsilanti, MI *48198
Sheet1

Any ideas? Thanks!

 

[VoG]

Try Data > Text to Columns, Delimited, tick Other as the delimiter then in the other box hold down ALT and type 0010 on the numeric keypad.

 

[anewc1]

WOW. Neat trick. Thanks!!