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?

Hi!

Use Text to Columns>Delimited>Other

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" <[email protected]> wrote in message
news:[email protected]...
> 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?

Data>Text to Columns>Delimited by>Other

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
<[email protected]> 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?