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

  • Thread starter Thread starter Sammy
  • Start date Start date
S

Sammy

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
 
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)
 
That separated the into colums (A1, B1. C1, D1, etc). I would like the
separation to be into rows.

Ron Coderre said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
That separated the into colums (A1, B1. C1, D1, etc). I would like the
separation to be into rows.

Ron Coderre said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top