Concatenate text with spaces and ignore blank cells, and also the first blank cell.

[kozlikmak]

Hi, i have a problem with my sheet. First of all sorry for my bad english. I want to concatenate text with spaces and to ignore blank cells. I have a formula =IF(B2="";"";B2)&IF(C2="";"";" "&C2)&IF(D2="";"";" "&D2)&IF(E2="";"";" "&E2)&IF(F2="";"";" "&F2)&IF(G2="";"";" "&G2), but it doesn't work for first blank cell. Can you suggest me the new formula or just change the current formula?

 

[Fluff]

Hi & welcome to MrExcel.

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[kozlikmak]

The 2016 version.

 

[Fluff]

The 2016 version.

Please update your profile to show this as requested. It save people having to ask.

 

[Fluff]

How about

=TRIM(B2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2)

 

[kozlikmak]

Oh, yes. That works, thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.