How to split Number and Alphabetical Characters from a Cell


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.

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)

1 Like

Thanks a lot Dmitry Gudkov. It is working perfectly.