Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I currently have the following data in column A:
Column A: 123-456-7890 123-456-7890 456-789-0123 / FAX: 123-456-9870 123-456-7890;123-654-7890 123-456-7890;123-654-7890FX1234567 0 ? #N/A 123-456-7890 x1234/fax:123-654-7890 123-456-7890/456-789-01234 123-456-7890; FAX:123-456-9870 123-456-7890 ID1234 123-456-7890 (team 1) 123-456-7890;FAX 321-456-7890 123-456-7890 x123 1-123-456-7890 direct 321-456-7890 fax: 123-456-7980 123-456-789 x1; FAX 123-456-9870 123-456-7890 Is there an easy way to transform this data into Column B so that it picks up the first set of phone numbers, so it reads: Column B: 123-456-7890 123-456-7890 123-456-7892 123-456-7893 NA NA NA 123-456-7897 123-456-7898 123-456-7899 123-456-7900 123-456-7901 123-456-7902 123-456-7903 123-456-7904 123-456-7905 123-456-7906 Thanks very much for your insight. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Links to External Database | Excel Discussion (Misc queries) |