Hi:

I have a cell containing Last and First Name. In most cases the
Lastname and Firstname are seperated by a comma. Also in this same
field there is a telephone number which can be in several different
formats (e.g (718-xxx-xxxx) or 718-xxx-xxxx)). I would like to extract
the phone number from this "Name" cell, leaving just the lastname and
the firstname. Seperating the names would be a bonus but I don't think
is possible, as there is no set patterns.

For the telephone number, there is another cell with telephone numbers
which is sometimes blank. What I'd like to do is, if I can extrapulate
the telephone number (formating it as 718-xx-1212) and place it in the
"telephone number cell", only if that cell is blank. This would be my
ultimate goal. Any help would be appreciated.

thanks

frank