79690040

Date: 2025-07-04 10:36:09
Score: 3
Natty:
Report link

The code works well to concatenate the 2 columns. How would you add a 'space' between the ranges such as in First_Name " " Last_Name " ? When I try to add the space, I get type mismatch

.Evaluate("=B:B & " " & D:D") ' Doesn't work with space added. Gives type mismatch

.Evaluate("=B:B&D:D")
Reasons:
  • Blacklisted phrase (1): How would you
  • Low length (0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Petra