Convert a number stored as text to number

Salman98

New Member
Joined
Jun 26, 2020
Messages
6
Office Version
  1. 365
Platform
  1. Windows
Hello
I have this array of numbers and alphabets stored as text as you may notice :{”6”;”4”;”1”;”D”;”R”}
I want to convert the numbers to numbers and let the text stored as text, it may look like this: {6;4;1;”D”;”R”}
is there a formula to work around that?
Any help will be very appreciated
Thank you
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,143
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Suggest you upload a sample workbook showing your data and a mocked up solution so that we understand exactly what you have and what you are looking to do. Please use the XL2BB function which is part of this forum to do the upload. Do not load a picture as we can not manipulate data in a picture.
 

Salman98

New Member
Joined
Jun 26, 2020
Messages
6
Office Version
  1. 365
Platform
  1. Windows
I could not insert the file
can you please help through these images of the file?
I want to extract the smallest alphabet on the list as shown in the yellow table
the problem that I faced is in the bigger table where I have mixed text with numbers and alphabets
thank you
 

Attachments

  • png.png
    png.png
    7.9 KB · Views: 14
  • tempsnip.png
    tempsnip.png
    9 KB · Views: 13

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,143
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
As I indicated, I cannot manipulate data in images. Hopefully, someone else will chime in here for you.
 

Salman98

New Member
Joined
Jun 26, 2020
Messages
6
Office Version
  1. 365
Platform
  1. Windows
Hope so
Thank you
Have a nice day
 

Watch MrExcel Video

Forum statistics

Threads
1,127,063
Messages
5,622,470
Members
415,897
Latest member
Barry18180

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top