splitting cell values

[Diane]

I have a cell value with something like this:

5830 Paradise Bay - wall
or
Hickory Woods 26 - footing

I need to divide these into two columns separated by the dash. So the
address will go in one column and the other term (wall, footing, etc) will
go into another.

Any ideas?

Thanks,
Diane

[Peo Sjoblom]

Make sure the column to the right is empty, if not select the column to the
right, right click the header and select insert, now select the column with
the text you want split, do data>text to columns, select delimited, click
next, check other and put in a dash there, click finish

--
Regards,

Peo Sjoblom

(No private emails please)


"Diane" <[email protected]> wrote in message
news:%23%[email protected]...
>I have a cell value with something like this:
>
> 5830 Paradise Bay - wall
> or
> Hickory Woods 26 - footing
>
> I need to divide these into two columns separated by the dash. So the
> address will go in one column and the other term (wall, footing, etc) will
> go into another.
>
> Any ideas?
>
> Thanks,
> Diane
>
>
>

[Dave Peterson]

Select the cell (or column of cells???)
and do data|text to columns
delimited
by other (type in the hyphen character)
and finish up.

Diane wrote:
>
> I have a cell value with something like this:
>
> 5830 Paradise Bay - wall
> or
> Hickory Woods 26 - footing
>
> I need to divide these into two columns separated by the dash. So the
> address will go in one column and the other term (wall, footing, etc) will
> go into another.
>
> Any ideas?
>
> Thanks,
> Diane

--

Dave Peterson

[Diane]

Thanks Peo and Dave. That's exactly what I needed. I couldn't remember where
it was!

Diane


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Select the cell (or column of cells???)
> and do data|text to columns
> delimited
> by other (type in the hyphen character)
> and finish up.
>
> Diane wrote:
>>
>> I have a cell value with something like this:
>>
>> 5830 Paradise Bay - wall
>> or
>> Hickory Woods 26 - footing
>>
>> I need to divide these into two columns separated by the dash. So the
>> address will go in one column and the other term (wall, footing, etc)
>> will
>> go into another.
>>
>> Any ideas?
>>
>> Thanks,
>> Diane
>
> --
>
> Dave Peterson