79639707

Date: 2025-05-27 01:11:18
Score: 10 🚩
Natty: 6.5
Report link

@Robin Gertenbach

This works beautifully. however, since I am adding some text to the concatenate, that text comes up also in the empty row.
Can you help me out please?
I am using this:

=ARRAYFORMULA($B$2:B &"mytext" &" " & $D$2:D)

so here, mytext appears on rows which are blank.

thanks

Reasons:
  • Blacklisted phrase (0.5): thanks
  • Blacklisted phrase (1): help me
  • RegEx Blacklisted phrase (3): Can you help me
  • RegEx Blacklisted phrase (2): help me out
  • Low length (0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Looks like a comment (1):
  • Low reputation (1):
Posted by: TasJam