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?
|