Did you try to us fixed width rather then delimited when using text to columns?

"JLD" wrote:

I have a sheet imported from Access. The cell has the following data from the
import...

602 E Church DR
#
Sugar Land, TX 77478-2612

My problem is the '#' symbol brought from the database. If I try to take
that column and convert from 'Text to Column' it cuts out the City & State
information. How can I get rid of the second line that has the '#' in it to
have the third line of data in cell?

Thanks,