Home |
Search |
Today's Posts |
#1
|
|||
|
|||
many numbers in one cell separated by hyphen.
Many numbers in one cell separated by hyphen. How to put them in separate
rows of one column? |
#2
|
|||
|
|||
one way:
Choose Data/Text to Columns. Select the Delimited radio button and choose Next. Enter a hyphen in the "Other" field, then click Finish. In article , "baju" wrote: Many numbers in one cell separated by hyphen. How to put them in separate rows of one column? |
#3
|
|||
|
|||
I would say the quickest way is to select the column and
do Data Text to Columns, using "-" as your delimiter. Then select the data, copy it, and Edit Paste Special Transpose. HTH Jason Atlanta, GA -----Original Message----- Many numbers in one cell separated by hyphen. How to put them in separate rows of one column? . |
#4
|
|||
|
|||
And then choose the resulting values, copy, then paste-special transpose to
get them into a column. HTH, Bernie MS Excel MVP "JE McGimpsey" wrote in message ... one way: Choose Data/Text to Columns. Select the Delimited radio button and choose Next. Enter a hyphen in the "Other" field, then click Finish. In article , "baju" wrote: Many numbers in one cell separated by hyphen. How to put them in separate rows of one column? |
#5
|
|||
|
|||
There are too many numbers (more than 256) to put them in columns first.
"Bernie Deitrick" пишет: And then choose the resulting values, copy, then paste-special transpose to get them into a column. HTH, Bernie MS Excel MVP "JE McGimpsey" wrote in message ... one way: Choose Data/Text to Columns. Select the Delimited radio button and choose Next. Enter a hyphen in the "Other" field, then click Finish. In article , "baju" wrote: Many numbers in one cell separated by hyphen. How to put them in separate rows of one column? |
#6
|
|||
|
|||
OK, try this. Assuming your value is in A1.
1. Put this in A2 and copy down until you get an error=20 value: =3DRIGHT(A1,LEN(A1)-FIND("-",A1)) 2. Put this in B1 and fill all the way down: =3DIF(ISERROR(FIND("-",A1)),A1,LEFT(A1,FIND("-",A1)-1)) HTH Jason Atlanta, GA -----Original Message----- There are too many numbers (more than 256) to put them=20 in columns first. "Bernie Deitrick" =D0=BF=D0=B8=D1^=D0=B5=D1,: And then choose the resulting values, copy, then paste- special transpose to get them into a column. =20 HTH, Bernie MS Excel MVP =20 "JE McGimpsey" wrote in message news:jemcgimpsey- ... one way: Choose Data/Text to Columns. Select the Delimited=20 radio button and choose Next. Enter a hyphen in the "Other" field,=20 then click Finish. In article <CA641783-057C-4AC2-BFD3- , "baju" wrote: Many numbers in one cell separated by hyphen. How =20 to put them in separate rows of one column? =20 =20 =20 . |
#7
|
|||
|
|||
Thank you, that works.
"Jason Morin" пишет: OK, try this. Assuming your value is in A1. 1. Put this in A2 and copy down until you get an error value: =RIGHT(A1,LEN(A1)-FIND("-",A1)) 2. Put this in B1 and fill all the way down: =IF(ISERROR(FIND("-",A1)),A1,LEFT(A1,FIND("-",A1)-1)) HTH Jason Atlanta, GA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
Sum cell numbers that have certain text within the cell | Excel Worksheet Functions | |||
Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |