Insert output in only one cell

Support
1

Hi everyone,

what I try to achieve is pulling the anchor texts of a domain into just one cell. The anchors can be divided by a comma "," or something else.

This would help me identfiying bad websites more quickly than accessing the Majestic / Ahrefs Interface all over again.

PLUS I could create another sheet with "blacklisted" anchors which would greatly increase my efficiency.

Thankful for your answers :smile:

2

Hi Max,

Yes, you can do it like this by combining Xpath, Dump and StringJoin:

image.png1470×470 83.8 KB

The "TRUE" argument means StringJoin should ignore empty entries.

3

Yup, StringJoin was the function I was looking for.

I should have figured this out by myself. Thank you for the help!! Awesome support :smile:

4

Please, help me with anchors ahref. This costruction doesnt work

=Dump(StringJoin(Connector("Ahrefs.Anchors";"google.com";"domain";;;"anchor";"asc";"Anchor";TRUE;40));"|";TRUE)

5

Can you be more specific about what doesn't work? Also, you don't need Dump when using StringJoin.