split numbers from text in Dashboard

[former_member221192]

Hi experts,

How to split the numbers from text combination,I have following data

in this data I have to take only numbers  like below

07331100000493

07331100000474

07331100000474

07331100000474

6959

2681020000002721

2681020000002721

2681020000002721

How to do help out this..

[Former Member]

Hi Ganapathy,

You can use  excel function to extract only numbers from string

please chk th eformula below

=SUMPRODUCT(MID(0&A13,LARGE(INDEX(ISNUMBER(--MID(A13,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)

here A13 is the cell value.

please find the attachment and change the extn to .xlsx.

Hope this helps you out

Book1.txt.zip

[former_member221192]

Hi Susma,

we are using different logic for getting numbers from  character.

Thank you for your suggestion

[former_member221192]

Hi susma,

we are using different logic for this

thank you for your valuable reply