| Author |
 Topic  |
|
|
kolucoms6
Average Member
845 Posts |
 Posted - 19 November 2007 : 14:44:50
|
1st 2nd Column
909090909 909090909
909090908 909090908
How to achieve it in Excel ? |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 19 November 2007 : 15:13:03
|
Once more - with clarity.
What exactly are you trying to do? |
 |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 19 November 2007 : 17:11:33
|
I have a colum with few Ph Number.
Once anyoen clicks on that phone number , it opens up a software and dial out that number
Column1--------------------------Coulmn2
001989786665--------------------------call:001989786665
call:001989786665 is a hyperlink... |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 20 November 2007 : 09:01:42
|
Excel should automatically recognize links in your files. However, I'm not sure how you'd have the link open a specific program. Typically the only links I've seen possible in Excel/Word/etc files were either mailto: links or simple links to web pages.
However, if you're just wanting to insert a hyperlink, in your file menu, click Inesert -> Hyperlink, or Ctrl+K. I don't know if it'll do what you need since I've never seen a way to open a program on a user's computer from a link, but if that gets you one step closer, then so be it. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 20 November 2007 : 14:36:52
|
Like in IE adress bar when i type,
sip:213123213
It openS up Xlite soft phone and dials out 213123213.
Now I want this same link in Excel, but created dynamically...
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 20 November 2007 : 14:58:51
|
It's not trivial - the hyperlink autosensing in Excel is pretty deep inside the programme
If you're into a bit of VBA (and can control the clients security settings, etc) you could try writing an extender/handler using the oncellselect (or whatever) event to programatically test for the string call:, then open the appropriate programme (with DDE or shell if you can't API it) and pass the number. Not trivial, I'm afraid. |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 02 December 2007 : 08:41:10
|
Here is it :
Suppose the Contact Tel Nos r in "Column" "A" with 10 digit US nos and the first Entry is in Cell A2 as 2127773456
1) Insert Three Columns after Column A i.e. New Column B C D
2) in B2 type sip: or sip:1 or sip:001 [whatever prefix your voip provider supports]
3) in C2 type =B2&A2 [this will effectively combine cells to look like sip:2127773456 or sip:12127773456 or sip:0012127773456]
4) in D2 type =HYPERLINK(C2, A2) [ this will again show your tel no with a underline like 2127773456]
Now Select B2:D2 and Drag or Corner Click for the Entire Row of Excel Data Contact Nos.
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 02 December 2007 : 10:53:59
|
Ha! well solved - I hadn't come across the HYPERLINK() function, and was thinking in terms of smarttagged autoreplace - genius :-)
For what it's worth, you can nest the functions to
=HYPERLINK((CONCATENATE("sip:001", $A2)),$A2) [this in cell B2, then copy down column B] |
Edited by - pdrg on 02 December 2007 10:56:28 |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 02 December 2007 : 17:35:59
|
| :-) |
|
|
| |
Topic |
|
Topic Locked
