Moving numbers from end of Excel cell into new column

Posted on 2012-09-19
Last Modified: 2012-09-19
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
Question by:LetsLearn
    LVL 18

    Accepted Solution


    If your data in A2, in B2,


    In C2



    Author Closing Comment

    Thank you Kris! That has saved me a huge amount of time.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now