=RIGHT(H8,12)
this function takes out the twelve characters from the right or you
could test out Data, text to columns, this worked with the small
example that you gave

Save your sheet in a different workbook name before you try this:
highlight the range you want to seperate the numbers
then goto the top menu and select
Data,text to Columns
select fixed width
next
double click on the lines you want to delete and only keep the line
that seperates the phone number from rest
press next
then finish
the numbers should be transferred to the next column
be carefull, this will replace anything that is in that column, so you
may have to insert a column before you do this


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564613