[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Moving numbers from end of Excel cell into new column

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
0
LetsLearn
Asked:
LetsLearn
1 Solution
 
krishnakrkcCommented:
Hi

If your data in A2, in B2,

=LEFT(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))-1)

In C2

=TRIM(SUBSTITUTE(A2,B2,""))

Kris
0
 
LetsLearnAuthor Commented:
Thank you Kris! That has saved me a huge amount of time.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now