Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2012, 01:53 PM
certified_techy certified_techy is offline Converting Phone Numbers Question Windows 7 64bit Converting Phone Numbers Question Office 2007
Novice
Converting Phone Numbers Question
 
Join Date: Apr 2012
Location: Nashville, TN
Posts: 2
certified_techy is on a distinguished road
Default


So, how would that look with a phone number in it? And how could I do a "find and replace" and get that added to the front (which is where I'm assuming it's supposed to go)?

Would it look like "=LEFT(A1,3)&"-"&MID(A1,4,3)&"-"&RIGHT(A1,4)1234567890" ?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Custom Labels for Phone numbers Tonistep Outlook 0 03-26-2012 02:57 PM
Can delete on phone but still dnlds to netbook peterlckwd Outlook 0 03-14-2012 04:29 AM
Converting Phone Numbers Question Changing phone categories in Outlook Contact cwksr Outlook 1 05-06-2011 08:44 AM
Converting Phone Numbers Question Phone number formatting Mark Micallef Outlook 1 08-04-2010 02:38 PM
Phone call through TAPI driver drdebate Outlook 0 04-09-2007 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft