Jump to content

Cre8asiteforums

Web Site Design, Usability, SEO & Marketing Discussion and Support

  • Announcements

    • cre8pc

      20 Years! Cre8asiteforums 1998 - 2018   01/18/2018

      Cre8asiteforums In Its 20th Year In case you didn't know, Internet Marketing Ninjas released many of the online forums they had acquired, such as WebmasterWorld, SEOChat, several DevShed properties and these forums back to their founders. You will notice a new user interface for Cre8asiteforums, the software was upgraded, and it was moved to a new server.  Founder, Kim Krause Berg, who was retained as forums Admin when the forums were sold, is the hotel manager here, with the help of long-time member, "iamlost" as backup. Kim is shouldering the expenses of keeping the place going, so if you have any inclination towards making a donation or putting up a banner, she is most appreciative of your financial support. 

Recommended Posts

Hi Everyone,

 

Would anyone know a faster way to put keywords in phrase match, exact match and broad match without having to type the "", []

 

I'm talking about using thousands of keywords and having to type "" or [] can be a pain.

 

Thanks

Share this post


Link to post
Share on other sites

Main-

 

I copy the listings into an Excel column and then write forumlas that add the extra bits.

 

You will want to create a concatenate function using a formula something like like this:

 

=+ " " & "<a target='_blank' title='" & B11 & ", "& $B$9 & "' href='" & C11 & "'>" & B11 & "</a>"

 

And you will need to lookup the synax for putting in double quotes since your output included quotation marks.

 

Finally, copy the results you get and then paste into another row using Paste Special | Values Only

 

Then copy that result and paste into the key add box. Fini.

 

-Jeff

Edited by Jozian

Share this post


Link to post
Share on other sites

Hi Jeff,

 

Thanks for the help. I have OpenOffice 2.0. Would you know if its possible to write code using that software ?

 

Thanks

Share this post


Link to post
Share on other sites

Main-

 

I am sure you can do it in OpenOffice.

 

The premise is the same, but the commands and formulas will likely be a little different.

 

BTW, I use this technique all the time to edit and enhance lists of items. Spreadsheets are great for simple data manipulations like your issue.

 

In fact, the formula I gave as an example is used to dynamically build wikipedia links to a list of cities. Once setup, all I do is paste in the names and the html code pops out :)

 

 

-Jeff

Share this post


Link to post
Share on other sites

×