Taking text from a cell leaving Phone#

[PokerZan]

Hello,

I have a list that was from a database exported as a CSV and I need to alter one cell that has a fax number in it. All the cells have this:

fax: 222-555-1234

I only need the phone number and need to take out the "fax: " What formula would I use to extract this text from the cell?

Thanks,
PZan

[Gary Brown]

=mid([cell where the fax number is],6,255)

[Alex Delamain]

You can also use "text to columns" found under the Data menu.

select the column containing the information then
Data, Text to columns
select delimited then next
on step 2 set the delimiter to "other" and :
then finish

It should leave you with a column containing "Fax" which can be deleted and a second column which just holds the numbers

[PokerZan]

Thanks guys, the formula that Gary first posted worked like a charm. I do appreciate the Text to Columns tip too, that will help I'm sure. I'm doing more and more text manipulation rather than model building lately so this should come in handy!

Thanks again,

PZan