Mobile Phone Number Format

L

Lorraine

I have a list of mobile numbers currently in 077... format and need to
convert to international i.e. +44
Is there a formula i can use to do this rather than editing each cell
 
J

Jacob Skaria

Try the below..

with your number in A1 try the below formula
="+44" & Mid(A1,2,15)

If this post helps click Yes
 
Top