Remove 1000 Keyword Limit [Limit raised to 5000]

Allen

ChancyRat wrote: »

Shaking my head over here. I've done some fancy concatenate formulas in Excel - really, I have.
But how did you do this part?

WAIT, got it! Text to columns. TahDah. Let me continue on here.

delimiter using dot

copy row, hightlight cell to rotate into, paste special, pick transpose

create columns to combine for link

Edit: Oops. <a href=" /keyword/birds+....

ChancyRat

Allan, thank you, I did get it in a snap once I had a duh-text-to-columns moment.
Concatenate is easier to use, I think, to combine the fields: concatenate=(A1,A2,A3,A4).

I also did have to remove some extra spaces that for some reason were inserted before and after each of my keywords, in the first copy-paste from the webpage, to Excel:
Find: space; replace with +
Caused two pluses to be inserted at various points (and one plus to be inserted properly)
Fix was:
Find: ++
Replace: [nothing]

Now, I see that Smugmug's new 5,000 limit probably means I haven't needed to do this page but it's a good exercise and I might keep it handy as a backup. [EDIT: Oops, this isn't the limit I care about. It's the 256 limit, so I will be using this page!]

For one more effect, can I widen the lines a smidgeon?

EDIT: I forgot I had to make one other tiny edit, adding a space before the bullet:
From: </a><span style="color: blue;">•</span>
To: </a><span style="color: blue;"> •</span>

Allen

ChancyRat wrote: »

Allan, thank you, I did get it in a snap once I had a duh-text-to-columns moment.
Concatenate is easier to use, I think, to combine the fields: concatenate=(A1,A2,A3,A4).

I also did have to remove some extra spaces that for some reason were inserted before and after each of my keywords, in the first copy-paste from the webpage, to Excel:
Find: space; replace with +
Caused two pluses to be inserted at various points (and one plus to be inserted properly)
Fix was:
Find: ++
Replace: [nothing]

Now, I see that Smugmug's new 5,000 limit probably means I haven't needed to do this page but it's a good exercise and I might keep it handy as a backup. [EDIT: Oops, this isn't the limit I care about. It's the 256 limit, so I will be using this page!]

For one more effect, can I widen the lines a smidgeon?

EDIT: I forgot I had to make one other tiny edit, adding a space before the bullet:
From: </a><span style="color: blue;">•</span>
To: </a><span style="color: blue;"> •</span>

What I like is you can edit the text for any KW just not the KW. I have a lot of bird name KW's with
dashes so I can now use a dash in the text for the real name.

ChancyRat

Allan I have spoken too soon. Why would some of the keywords, when clicked, result in no photos found?

ChancyRat

Allan, not sure if you saw this one request: For one more effect, can I widen the lines a smidgen?

Allen

ChancyRat wrote: »

Allan I have spoken too soon. Why would some of the keywords, when clicked, result in no photos found?

Any single quotes in them. Videos will not show either.