Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
functions:extract_number_from_text [2016/02/16 16:22]
metecuma
functions:extract_number_from_text [2016/02/16 17:00]
metecuma
Line 9: Line 9:
 // Adapted from [[http://​www.ozgrid.com/​VBA/​ExtractNum.htm|http://​www.ozgrid.com/​VBA/​ExtractNum.htm]] \\ // // Adapted from [[http://​www.ozgrid.com/​VBA/​ExtractNum.htm|http://​www.ozgrid.com/​VBA/​ExtractNum.htm]] \\ //
 By using this function, you can extract numeric part of alphanumeric text. According to your needs, you may extract numbers with decimal sign and/or negative sign. \\ By using this function, you can extract numeric part of alphanumeric text. According to your needs, you may extract numbers with decimal sign and/or negative sign. \\
 +  =Extract_Number_From_Text(Value,​ Include_Decimal,​ Include_Negative)
 At the figure below, you can see using of parameters; \\ At the figure below, you can see using of parameters; \\
 {{functions:​extract_number_from_text.png?​nolink|samples of extracting number from text}} \\ {{functions:​extract_number_from_text.png?​nolink|samples of extracting number from text}} \\