Excel Column

C# Corner

Excel Column

Ramco Ramco

3y871.NET

In excel i have one column Age . It has value - 11.2 years

i want only 11.2 , i want to remove any alphabetic values .

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P3y ago
I think you have one space after age value after that you added 'years' right, then you can do that cell value.ToString().split(' ')[0]; to get first before space value.

Hope it will be helpfull to you.
0

Naimish Makwana3y ago

Hello Ramco,

Use regex as below:

 string age = "11.2 years";
        
        // Use regular expression to extract numerical value
        string numericalValue = Regex.Match(age, @"[-]?\d+(\.\d+)?").Value;
        
        Console.WriteLine(numericalValue);

Thanks

Naimish Makwana