Assuming all of your data follows the same format as your example, these
formulas should work:

=SUBSTITUTE(LEFT(A1,12),"-","")

=MID(A1,FIND(" ",A1)+1,FIND("~",SUBSTITUTE(A1,"
","~",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-FIND(" ",A1)-1)&",
"&MID(A1,FIND("/",A1)+1,FIND(" ",A1)-FIND("/",A1)-1)

=RIGHT(A1,7)

HTH,
Elkar

"Penny" wrote:

I have xxx-xxx-xxxx(followed by a /) FirstName LastName xx-xxxx all in the
same cell (ie: 865-356-8434/Curtis Gogel 01-AUDT) but would like to have :
8653568434(no dashes)|Gogel, Curtis|01-AUDT.

Is it possible to "tweak" the excel cell info from ONE cell into three,
appearing as such listed above?