How do I split a one cell which has a hard return?
 

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?

How do I split a one cell which has a hard return?
 

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?

How do I split a one cell which has a hard return?
 

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?