Hyperlink and Phone Number

[naeemdotcom]

Hi All,

I wonder if its possible that if i write a phone number in Col A then it generates or somehow create following hyperlink in Col B which includes the phone number from Col A.

Required Hyperlink in Col B.
http://www.xyz.com/1122334455

Here '1122334455' is the phone number that comes from Col A.

Any help would be great.

-naeemdotcom

[Glenn Kennedy]

Is this what you mean?
=HYPERLINK("www.xyz.com/ "&A1)

[naeemdotcom]

its working..

[AliGW]

Try this:

=HYPERLINK("http://www.xyz.com/"&A1)

[naeemdotcom]

yes thats working. Thanks
what if the phone number from Col A is in the middle of hyperlink.

[Glenn Kennedy]

I messed up, I think. Ali's answer will do it. Can you explain what you mean by your comment at Post #5?

[naeemdotcom]

It looks like both the answers are same.. yours and Ali, effectively same. Both are working fine.

explaining Post#5:
Let us say that i want the phone no of Col A in the middle of the hyperlink instead of at the last of it.
Middle means something like this: http://www.xxx.yyy/33445566/uuu.php
Here 33445566 is the phone number but the hyperlink do not end here and there is remaining part of it that comes after the phone number.

Any idea how to do this?

[AliGW]

Perhaps like this:

=HYPERLINK("http://www.xxx.yyy/"&A1&"/uuu.php")

[naeemdotcom]

thanks its working.

[AliGW]

You're welcome!