Thread
:
8500 cells with phone number(7 char.), wishing to add area code (10 char.)
View Single Post
#
6
Posted to microsoft.public.excel.misc
Pete_UK
Posts: n/a
8500 cells with phone number(7 char.), wishing to add area code (1
You could save yourself manally converting the numbers back by amending
your formula to:
=IF(LEN(A1)7,A1,E1&A1)
Hope this helps.
Pete
Reply With Quote