Hi, I have Excel spreadsheets which have a column of names with index numbers,
Coleman, Janet 456-458, 610
Smith, John 99, 105, 175
Finkleman, Fred 54, 98, 104-107, 210
I have been using the text to column function however then I have to merge the numbers back together into one column.
I need to create one column with the index numbers only.
Many thanks in advance