Any quick way of tidying up a very long list of telephone numbers, need to do three things
replace all numbers with +44 with 0 at start.
Remove any commas in the name section and
remove text after numbers in the mobile column.
The file has just two columns, name and mobile and needs to be in a CSV format to import into our phone system (Avaya)
The first one being the most important.