Uk Mobile Telephone Numbers

With formulas and native excel functions....

in 4 separate available column, enter in the first column

=IF(OR(LEFT(A1,3)={"077","078","079"}),A1,IF(OR(LEFT(A1,2)={"77","78","79"}),0&A1,""))

this checks first that the first 3 digits are those you are lookiing for and if yes, copies it, else it assumes you want to check if the first 2 digits, and if they match the 2 digit codes, it adds a 0 in front of the number...... make sure this would work for your data.

where A1 contains the top left most number in your original data.

Copy over 4 columsn and down as far as needed.

Then select the original 4 columns and go to Format|Cells and choose Text from the Number tab.

Then copy the new 4 columns and go to A1 and then Edit|Paste Special and choose Values...

then you can delete the 4 formula columns.

Now select the original 4 columns and go to Format|Conditional formatting.

Choose Formula Is and enter formula:

=OR(LEFT(A1,3)="077",LEFT(A1,3)="078",LEFT(A1,3)="078")

where A1 is again the top-left most cell in the selection.

click Format and choose colour from Pattern tab.

This highlights all numbers starting with your 3 criteria.