Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to number lists separated by a space on Excel? | Excel Discussion (Misc queries) | |||
Seperate cell string into individual cells | Excel Worksheet Functions | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Coverting string of text into individual sums? | Excel Discussion (Misc queries) |