how do i turn text into links?

Bartman · Jul 6, 2011

hi guys
i cant believe i am so stupid
I have a list of links in excel
link 1
link 2
link 3

I want to place these on a html page and then upload the page to my website.
I tried copy/paste in Kompozer, but the links are not recognized, they are unclickable, they are text. how can I turn them into links?

seondeveloper · Jul 6, 2011

Are you directly pasting links from excel to webpage?? I think this is because of format that excel that is being taken in webpage

Bartman · Jul 6, 2011

seondeveloper said:
Are you directly pasting links from excel to webpage?? I think this is because of format that excel that is being taken in webpage

yes, i also tried excel to notepad to webpage

tonlilaz · Jul 6, 2011

is this what you're looking for?
http://excel.tips.net/T003110_Converting_a_Range_of_URLs_to_Hyperlinks.html

wannabie · Jul 6, 2011

Let me guess, you're an "Seo"

purewealthinc · Jul 6, 2011

Mate,

Just do it manually to add those links in your webpage and you are good to go.

Just type this code

<a href="Link 1 or your web URL address">Link text or type here click here or visit here </a>

Simple as that..

RaWsToNe · Jul 6, 2011

purewealthinc said:
Mate,

Just do it manually to add those links in your webpage and you are good to go.

Just type this code

<a href="Link 1 or your web URL address">Link text or type here click here or visit here </a>

Simple as that..

haha right? i thought black hat members would be a little more advanced than this.. lmfao

Bartman · Jul 6, 2011

purewealthinc said:
Mate,

Just do it manually to add those links in your webpage and you are good to go.

Just type this code

<a href="Link 1 or your web URL address">Link text or type here click here or visit here </a>

Simple as that..

200 times?

Autumn · Jul 6, 2011

Save this script as urls_to_links.php and upload it to your hosting. Paste your links into the text box and it will give you back a list of hyperlinks. Then you can view source if you want to copy and paste the actual html.

Code:

<?php

// Text urls to hyperlinks
// By Autumn @ BHW

if($_POST['save'] == 'yes') {

	// Print links
	$urls = $_POST['urls'];

	$urls = explode("\n", $urls);

	foreach($urls as $url) {
		echo "<a href=\"$url\" target=\"_blank\">$url</a><br>\n";
	}

	exit;


}

	// Print form
	echo '<html>
<head>
<title>URLs to links</title>
</head>
<body>
Enter your urls:<br>
<form action="'. $_SERVER['PHP_SELF'] .'" method="post">
<input type="hidden" name="save" value="yes">
<textarea name="urls" rows="30" cols="60"></textarea><br>
<input type="submit" name="submit" value="Convert to links">
</form>
<br>
</body>
</html>';


?>

freeufcdotinfo · Jul 6, 2011

1) Place text (html) in to notepad
2) find text you want (keyword)
3) Press CTRL+h (replace) the keyword with <a href="Link 1 or your web URL address">Link text or type here click here or visit here </a>

If it helps click thanks

purewealthinc · Jul 7, 2011

Bartman said:
200 times?

Absolutely Yes mate if you are not lazy.. You can do it manually mate, i did some manual hyperlinks on my blogs because im not lazy when it comes to writing mate..

200 links or URL to make it a hyperlinks takes 2 to 3 minutes for me..

JM100988 · Jul 7, 2011

Use the CONCATENATE function in excel. All you gotta do is pick your format for the links, place it in a CONCATENATE function and you will have all your links in a second. No coding, no crazy sh!t, just CONCATENATE.

how do i turn text into links?

Bartman

Power Member

seondeveloper

BANNED

Bartman

Power Member

tonlilaz

Elite Member

wannabie

Elite Member

purewealthinc

Regular Member

RaWsToNe

Newbie

Bartman

Power Member

Autumn

Elite Member

freeufcdotinfo

Power Member

purewealthinc

Regular Member

JM100988

Newbie

Main Menu

Marketplace

Making Money

BlackHat World