Excel 2003 - A string of #s needs to be separated into individual
 

I have a string of number in one cell separated by semicolons. How does I
get Excel to place each number in an individual cells? Is there a way to use
the "Find and Replace" option to do this. the string looks like:
1;2;3;4;5;6;7 i'd like 1 to be in a cell 2 to be in a different cell and so
on. Also, I would like them to move downward in the cells (A1, A2, A3, A4,
A5, etc).

Thanks

Excel 2003 - A string of #s needs to be separated into individual
 

Try this:

Select the single column range of cells

From the Excel Main Menu:
<data<text-to-columns
....Check: Delimited...Click: [Next]
....Check: Semicolon
....Click: [Finish]

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Sammy" wrote in message
...
I have a string of number in one cell separated by semicolons. How does I
get Excel to place each number in an individual cells? Is there a way to
use
the "Find and Replace" option to do this. the string looks like:
1;2;3;4;5;6;7 i'd like 1 to be in a cell 2 to be in a different cell and
so
on. Also, I would like them to move downward in the cells (A1, A2, A3,
A4,
A5, etc).

Thanks

Excel 2003 - A string of #s needs to be separated into individ
 

That separated the into colums (A1, B1. C1, D1, etc). I would like the
separation to be into rows.

"Ron Coderre" wrote:

Try this:

Select the single column range of cells

From the Excel Main Menu:
<data<text-to-columns
....Check: Delimited...Click: [Next]
....Check: Semicolon
....Click: [Finish]

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Sammy" wrote in message
...
I have a string of number in one cell separated by semicolons. How does I
get Excel to place each number in an individual cells? Is there a way to
use
the "Find and Replace" option to do this. the string looks like:
1;2;3;4;5;6;7 i'd like 1 to be in a cell 2 to be in a different cell and
so
on. Also, I would like them to move downward in the cells (A1, A2, A3,
A4,
A5, etc).

Thanks

Excel 2003 - A string of #s needs to be separated into individ
 

My apologies....I read it...but, I didn't *see* it. : \

If you only have one cell to work with...
Follow my previous instructions..Then

Select B1:D1

<edit<copy
Select A2
<edit<paste special...Check: Transpose....Click [OK]
Clear B1:D1

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)



"Sammy" wrote in message
...
That separated the into colums (A1, B1. C1, D1, etc). I would like the
separation to be into rows.

"Ron Coderre" wrote:

Try this:

Select the single column range of cells

From the Excel Main Menu:
<data<text-to-columns
....Check: Delimited...Click: [Next]
....Check: Semicolon
....Click: [Finish]

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Sammy" wrote in message
...
I have a string of number in one cell separated by semicolons. How does
I
get Excel to place each number in an individual cells? Is there a way
to
use
the "Find and Replace" option to do this. the string looks like:
1;2;3;4;5;6;7 i'd like 1 to be in a cell 2 to be in a different cell
and
so
on. Also, I would like them to move downward in the cells (A1, A2, A3,
A4,
A5, etc).

Thanks