many numbers in one cell separated by hyphen.

[Guest]

Many numbers in one cell separated by hyphen. How to put them in separate
rows of one column?

 

[JE McGimpsey]

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.

 

[Jason Morin]

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

 

[Bernie Deitrick]

And then choose the resulting values, copy, then paste-special transpose to
get them into a column.

HTH,
Bernie
MS Excel MVP

 

[Guest]

There are too many numbers (more than 256) to put them in columns first.

"Bernie Deitrick" пишет:

 

[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

-----Original Message-----
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

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.

 

[Guest]

Thank you, that works.

"Jason Morin" пишет: