Word macro to convert from a vertical list to a horizontal list (separated by comma)

michael szpakowski - list

Let’s say you have a list:

word1

word2

word3

You need to convert this into:

word1, word2, word3

Sure, it’s not hard to do it just one time. But what happens if you need this on a regular basis?

I’ve created a Microsoft Word macro that helps with that.

You have an empty document looking like this:

word1

word2

word3

It will convert this into:

word1, word2, word3

In the end, after you run it, it cuts the data, all you need is to paste.

Sub Din_Enter_in_virgula_Din_Lista_Verticala_in_Lista_Orizontala()

‘ Macro1 Macro


Selection.WholeStory
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = “^p”
.Replacement.Text = “, ”
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll

Selection.WholeStory
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = “, ^p”
.Replacement.Text = “”
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
Selection.Cut

End Sub

You can add a macro to quick launch in Word, and this is how to install macros in Word.

Citește mai departeWord macro to convert from a vertical list to a horizontal list (separated by comma)

Small WordPress tip on categories

WordPress Logo

Let’s say you want to choose some categories for your blog (I wrote in Romanian why you shouldn’t, generally, use tags on WordPress, but, instead, categories – Ce alegi între categorii și etichete pentru articolele WordPress? – Blog de Olivian Breda).

You have three categories:

Category 1

Category 2

Category 3

In my opinion, the best solution is to also have another category,

zzz. Uncategorized

, and have this as a default.

So, when you will post a new article on the blog, you will be forced to pick between categories 1-3.

But, in case you will forget to pick a category, the blog post will automatically be assigned to category “zzz. Uncategorized”.

It will be then easy to see that there’s something wrong, as the category

“zzz. Uncategorized”

, which should have zero articles in it, now has one blog post.

Citește mai departeSmall WordPress tip on categories

Ce să implementați dintr-un audit SEO / UX realizat de mine?

HD - Internet

Ce recomand spre implementare în urma unui audit SEO / UX realizat?

  • Întâi de toate, e nevoie de spirit critic. Nu tot ce recomand e și valid 100%.
  • Apoi, poate fi vorba de dificultăți în implementare. Pot recomanda lucruri care nu se implementează ușor.
  • Mai e și vorba de perspective diferite. E posibil să îmi scape detalii vizibile altora.
  • În fine, lucrurile trebuie prioritizate. Se pornește de la low-hanging fruits, lucrurile din audit ușor de implementat și cu impact puternic, și se încheie cu lucrurile greu de implementat și cu impact mic.

Citește mai departeCe să implementați dintr-un audit SEO / UX realizat de mine?

Testimonials vs. Experience

Mr. Nixter - Transformative Experience

In a portfolio, in my opinion, there should be two things, at the same time:

  • Testimonials / case studies / sample projects – of course, generally people choose to showcase their best results. They’re an important thing to add to a portfolio page.
  • Experience – how many clients, how many years, how much effort – give me some numbers to help me understand what’s your level of expertise.

These two go hand in hand.

You need some case studies, to go deep and make the visitor have an idea of what you can do.

You also need to list your experience, so that the viewer of your portfolio understands what’s your overall knowledge.

Don’t miss either of them.

Citește mai departeTestimonials vs. Experience

Cum se pot gasi cuvintele cheie care au o tendința de creștere în căutări?

John - As Deep As Skin

Răspunsul la întrebare e mai nuanțat..

Google Trends arată astfel de lucruri, dar e un pic anevoios de folosit (trebuie să luați cuvânt cu cuvânt, și nu sunt date precise, ci, cum întrebați, trenduri.

În Google Search Console puteți vedea mai ușor evoluția unor cuvinte, dar sunt doar cuvintele pentru care rankează siteul vostru.

SEO Monitor au un instrument de predicție, e un tool foarte bun, e premium.

Pe de altă parte, predicțiile nu sunt exacte, se pot face estimări, dar nu există garanții.

Tooluri de cuvinte cheie se găsesc în partea finală a articolului acestuia »

Sunt acolo mai multe resurse despre cum se face research-ul de cuvinte cheie.

Citește mai departeCum se pot gasi cuvintele cheie care au o tendința de creștere în căutări?

Resurse despre emoji-uri / emoticoane în texte (subject line / meta descriptions)

Elias Rovielo - Emoji esculptures, República Subway Station, São Paulo, Brazil

Găsiți mai jos câteva resurse despre emoji-uri / emoticoane în texte (subject line / meta descriptions):

Opinia mea despre asta?

  • Cred că a fost un tend vizibil ascendent când au început să fie folosite.
  • În prezent, sunt destul de neutru referitor la folosirea lor. Există nișe (produse destinate copiilor; site-uri axate pe umor) unde pot ajuta; există nișe (lucruri serioase, business-uri cu reputație) unde pot face rău.
  • În general, în prezent, le evit, dar dacă văd un text cu emoticoane nu consider neapărat că va afecta negativ rata de conversie

Citește mai departeResurse despre emoji-uri / emoticoane în texte (subject line / meta descriptions)

Printscreens of fragments of texts are overrated

Tim Meaney - official

Let’s say you see a message on a web site which disturbs you some way or another, it annoys you, it offends you, you find it immoral, various other things.

You might think it’s a good idea to either take a picture of the screen (quite a non-technical solution), or just hit PrintScreen on a Windows PC and paste it in a Paint image/Microsoft Word document.

The thing is, it can be quite easy to change what you see on the screen, to manipulate the message.

If you’re using Chrome / FireFox / Safari / Edge (and I wonder what else would you use, if you’re in 98% of Internet users), you can read about document.designMode = ‘on’:

As you can see, it’s so easy to change the text in a page, that even if you do take a screenshot, that may not count as a proof for “But that web site, on date X, said Y”.

A better solution is to use an external tool to save the contents of the page and put a time stamp on it.

I will only link to a Google search because this kind of tool needs to be used for a while, and online tools tend to disappear after a while, and I won’t edit this article very soon. So, a Google search »

One web site which might disappear someday »

What a web site like this is to visit the page for you and save it and put a time stamp. There are multiple solutions for this.

Citește mai departePrintscreens of fragments of texts are overrated

Second-best articles when you have nothing to write about

Neil Conway - Research

One guy I like to follow online writes, from time to time, very good articles on how to write like:

From time to time, I suggest other people – “Hey, you should write, too! Start a blog! Just start writing, start from somewhere!”.

And, sometimes, I get this reply “But I can’t write 10x better articles than my competition!”.

This blog post is dedicated to those people.

The best kind of articles is when you come up with something new.

Some people (Derek Sivers, Seth Godin) manage, somehow, to produce a lot of content which is both new and high quality. Never seen before, and top-notch quality.

Let’s say you lack the creativity to write an article. I have this problem, myself. While I try to post mostly unique things on my blog, I’m only proud of a handful of articles on my blog.

What to do, then, if you have nothing to say, but you know that, still, you should flex your muscles and keep trying to write quality articles, all the time, even if most of them are hard to make?

I give you the one, top-notch, incredibly good, ultra, mega, giga, tera, solution! It’s called “research“.

If you have a blog on a certain subject, there are certainly some themes, subjects, which have been analyzed by others. Create original research starting from 5, 10, 20, perhaps even more articles on the matter. Create a huge, mega, giga, tera, article, summarizing all those articles you read about. Give references, of course, but don’t just copy & paste paragraphs, but make your own contribution. Rewrite everything, and give credit where it’s due.

Sure, these articles aren’t the best you can create. But they’re second-best, and you should do this.

In time, by reading and writing a lot of articles like these, you’ll get, I’m pretty sure of it, the ability to write original articles.

So, do “research” (the quotes are a bit of a joke, the research should be real).

Citește mai departeSecond-best articles when you have nothing to write about