Good Day,
I am looking for help on extending/adjusting my current formula.
Currently I am using : =REPLACE("("&LEFT(A1,3)&") "&RIGHT(A1,LEN(A1)-3),10,,"-")
to do the following:
A B
1 0436423447 (043) 642-3447
I now want help to do more or less the same, as per example below.
A B
1 0436123456 0431234567 (043) 612-3456 (043) 123-4567
Any suggestions?Attachment 384324
Last edited by Helgard25; 03-20-2015 at 06:46 AM.
Please post an Excel sheet. I can't tell where one cell stops and another one starts!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
See excel sheet above in my original post. Sorry about that
Hi - it hasn't appearred...
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Uploaded
Try this. Not pretty - but it seems to work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks