| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers in cell to individual rows in excel?
I have a spreadsheet that has many cells with up to 50 different account
numbers in the cell that need to be converted to individual rows within the sheet. How can I accomplish this task? Thanks for any help you can provide. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers in cell to individual rows in excel?
There good built-in functions to help you.
1. use Text to Columns to move the account numbers from a single cell to one cell each in the same row. 2. use the TRANSPOSE() function to data in the rows to columns. -- Gary's Student gsnu200708 "cemun" wrote: I have a spreadsheet that has many cells with up to 50 different account numbers in the cell that need to be converted to individual rows within the sheet. How can I accomplish this task? Thanks for any help you can provide. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers in cell to individual rows in excel?
That would be great for columns, but I need the information to be converted
to rows. The cell might look like this: 123452 152233 45232 255422 I need a row for each number. "Gary''s Student" wrote: There good built-in functions to help you. 1. use Text to Columns to move the account numbers from a single cell to one cell each in the same row. 2. use the TRANSPOSE() function to data in the rows to columns. -- Gary's Student gsnu200708 "cemun" wrote: I have a spreadsheet that has many cells with up to 50 different account numbers in the cell that need to be converted to individual rows within the sheet. How can I accomplish this task? Thanks for any help you can provide. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers in cell to individual rows in excel?
Then all you need is Text to columns. Just for example, if A1 contained your
posted data: 123452 152233 45232 255422 then Text to Columns could put 123452 in B1 152233 in C1 45232 in D1 255422 in E1 At this point, individual cells (all in the same row) and =TRANSPOSE(B1:E1) as an array formula will put: 123452 in A2 152233 in A3 45232 in A4 255422 in A5 At this point, individual cells, each in its own row -- Gary's Student gsnu200708 "cemun" wrote: That would be great for columns, but I need the information to be converted to rows. The cell might look like this: 123452 152233 45232 255422 I need a row for each number. "Gary''s Student" wrote: There good built-in functions to help you. 1. use Text to Columns to move the account numbers from a single cell to one cell each in the same row. 2. use the TRANSPOSE() function to data in the rows to columns. -- Gary's Student gsnu200708 "cemun" wrote: I have a spreadsheet that has many cells with up to 50 different account numbers in the cell that need to be converted to individual rows within the sheet. How can I accomplish this task? Thanks for any help you can provide. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers in cell to individual rows in excel?
Instead of columns, I need rows.
cell: 123452 152233 45232 255422 converted data to Row: 1) 123452 2) 152233 3) 45232 4) 255422 "Gary''s Student" wrote: Then all you need is Text to columns. Just for example, if A1 contained your posted data: 123452 152233 45232 255422 then Text to Columns could put 123452 in B1 152233 in C1 45232 in D1 255422 in E1 At this point, individual cells (all in the same row) and =TRANSPOSE(B1:E1) as an array formula will put: 123452 in A2 152233 in A3 45232 in A4 255422 in A5 At this point, individual cells, each in its own row -- Gary's Student gsnu200708 "cemun" wrote: That would be great for columns, but I need the information to be converted to rows. The cell might look like this: 123452 152233 45232 255422 I need a row for each number. "Gary''s Student" wrote: There good built-in functions to help you. 1. use Text to Columns to move the account numbers from a single cell to one cell each in the same row. 2. use the TRANSPOSE() function to data in the rows to columns. -- Gary's Student gsnu200708 "cemun" wrote: I have a spreadsheet that has many cells with up to 50 different account numbers in the cell that need to be converted to individual rows within the sheet. How can I accomplish this task? Thanks for any help you can provide. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert numbers in cell to individual rows in excel?
Re-read the posting.
Two steps........break the numbers across 50 columns then transpose to 50 rows in one column. Gord Dibben MS Excel MVP On Mon, 26 Feb 2007 08:22:18 -0800, cemun wrote: That would be great for columns, but I need the information to be converted to rows. The cell might look like this: 123452 152233 45232 255422 I need a row for each number. "Gary''s Student" wrote: There good built-in functions to help you. 1. use Text to Columns to move the account numbers from a single cell to one cell each in the same row. 2. use the TRANSPOSE() function to data in the rows to columns. -- Gary's Student gsnu200708 "cemun" wrote: I have a spreadsheet that has many cells with up to 50 different account numbers in the cell that need to be converted to individual rows within the sheet. How can I accomplish this task? Thanks for any help you can provide. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
| How do I Time stamp individual rows in excel? | Excel Discussion (Misc queries) | |||
| Is there a limit on selecting individual rows in excel? | Excel Discussion (Misc queries) | |||
| Can you plot individual numbers on a bell curve in excel, and how. | Excel Discussion (Misc queries) | |||
| combining several individual cells of numbers into one cell | Excel Worksheet Functions | |||
Linear Mode
