Search code examples
excelexcel-formuladataformat

Excel mixed data into number format

I have mixed data in my Excel sheet containing both text and numbers(in text format). How can I convert only numbers into (number format)?

The first row contains names with roll numbers (mixed) and the second contains numbers and '-' mixed. How shall I convert these numbers (in text form) into number format

Solution

  • Choose column you want to convert and then Data -> Text to Columns

    enter image description here

    In freshly opened Wizard choose Delimited -> Next -> Choose Delimiter Tab -> Next -> Choose General -> Finish

    Repeat steps for both columns if needed. Result:

    enter image description here

    Also this question is more suitable for Superuser site