The cell has an street address and then a hard return and on the second line
an apt #. Test to columns does not work because the street addresses vary in
length. Any ideas?

Hi!

Use Text to ColumnsDelimitedOther

With the cursor in the little box marked OTHER, hold down the ALT key and
using the *numeric key pad* type 010.

Then complete the steps in the T to C wizard.

Biff

"GatorGirl" wrote in message
...
The cell has an street address and then a hard return and on the second
line
an apt #. Test to columns does not work because the street addresses vary
in
length. Any ideas?

Do you want to split the cell at the hard return?

DataText to ColumnsDelimited byOther

ALT + 0010 will enter the hard return in the other box.

Hit Finish to split.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 13:28:02 -0700, GatorGirl
wrote:

The cell has an street address and then a hard return and on the second line
an apt #. Test to columns does not work because the street addresses vary in
length. Any ideas?