Search as I might I cannot find the best method to dial a telephone number via a button click?
I also need to change & add STD codes to telephone numbers. The standard input will be a full 11 digit number with no spaces, how would I break the number down into 5 / 6 eg current number 01223456789 in a single cell transferred to two cells eg A1=01223 B1=456789.
I hope this makes sense & you are able to offer solutions to one or both of the problems
VOG - I have removed my modem as I am now on broadband. The program "Dialer.EXE" is only available with a modem installed, is this a fair assumption or could the code in the link you provided be at fault!!
Nope I cant seem to find the formula to display only the first 5 digits of a telephone number in cell B1 & the remaining 6 digits to be displayed in C1 assuming the whole number in entered into cell A1!!
As VoG™ advised earlier, you can use the Data - Text to Columns facility. If you want the number to be complete in A1, STD in B1 and Tel in C1, then you must start by copying the number from A1 to B1, this is because during the process of conversion to 2 (or more)columns, the original cell retains the first element of the split.
You would then select B1 and use the wizard as advised, when you are advised to click, click on the number displayed
This thread is now locked and can not be replied to.