I'm trying to separate out this data that is stored in one field:

Sari
Panama - Pacific Point

I need to basically write a function that extracts Panama - Pacific
Point out and puts it into a new field but am not having any luck with
the help in Excel for this function. Can anyone help??


--
gemispence
------------------------------------------------------------------------
gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113
View this thread: http://www.excelforum.com/showthread...hreadid=568449