need to remove the xml code from a cell

Topic

New Reply

I have a sql database having xml fields for phone numbers, when I transfer the field to excel i get a lot of unwanted xml code

here is an example

1
Travail
450-430-2000
</Teleph

How can I remove everthing but the 10 didgit phone number or just extract into another cell the 10 didgit 0r 12 character phone number.

Richard

Reply | Quote

Replies

I found a way using the find and subtring function, but i need to find three distinct area codes 514 ou 450 or 819

Reply | Quote

You can do a 3 finds (grouped with an OR) for “514-“, “450-” , and “819-”

Steve

Reply | Quote