Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.

Other versions of Excel may work differently. Extracting, parsing ... The first argument is “Text,” which is the text string we want to split. The second argument is Col_delimiter, which is the ...

I was wondering if anyone has a quick and dirty way to do the following:<BR><BR>I have a spreadsheet of a couple of hundred rows. All of them have a column of email addresses that has been filled out.