How to split Number and Alphabetical Characters from a Cell

paramasivan.k · September 10, 2019, 11:39am

Hi,

I need to know how we can split the Number and Character which is present in a single excel cell.
Ex: 1003440031947500 (Old Gift Card number) = 1003440031947500.

dgudkov · September 10, 2019, 1:58pm

Hi Paramasivan and welcome to the Community!

You can use the keepchars() function to keep only digits. See the example below:

extract-number.morph (1.4 KB)

paramasivan.k · September 11, 2019, 4:24am

Thanks a lot Dmitry Gudkov. It is working perfectly.