How to extract neumeric values only seperated with commas from a string

[#1]

Hi All,

I have a string like

Ex:

210 sample, 220 single, 230 one, 240 abcvalue

I want only neumeric values seperated with commas.

How can i extract the neumeric values.

Thanks.....

[swuehl · Accepted solution]

Hi, try the keepchar function:

=keepchar ( '210 sample, 220 single, 230 one, 240 abcvalue ','0123456789,' )

[#3]

Hi Swuehl,

Thanks for your reply

It is working....

Thanks...