concatenate with ISBLANK and delimiter

Question

I am attempting to combine two columns in Excel 2016, with a space between the results. My problem is being able to use ISBLANK to ignore blanks on either column, and still have the space delimiter in the final result when two fields are combined.

Example:

enter image description here

score 1 · Accepted Answer · answered Jul 21 '22 at 23:29

1

If you have data in columns A and B and if you only want a space if there is data in both columns, then something like this will work.

=A1&IF(AND(A1<>"",B1<>"")," ","")&B1

answered Jul 21 '22 at 23:29

FlexYourData

6,430
2
6
21

score 1 · Answer 2 · answered Jul 22 '22 at 04:12

1

Try TEXTJOIN function:

=TEXTJOIN(" ",TRUE,A1,B1)

answered Jul 22 '22 at 04:12

Lee

2,923
1
6
8

Thanks Lee, but TEXTJOIN is not available in my Excel 2016 version. – Rick Kirkman Jul 22 '22 at 20:20

concatenate with ISBLANK and delimiter

2 Answers2