Concatenate

[Xirom431]

Hi, I need help with VBA to concatenate info base on data in cells of Column.

My sheet has header info on Row 1
Rows have range from 1 to 500
Column range is A to AY
If cells in D column contain number 57600, concatenate cells B & D and enter info into column AE to AY cells
if not, concatenate cells in B & D and each AE to AY header info and enter it into column AE to AY cells.
Thanks for the help in advance.

 

[Fluff]

How about in E2 copied down & across

=TEXTJOIN(".",1,$B2,$D2,IF($D2=57600,"",E$1))

 

[Xirom431]

It worked. Your quick response is highly appreciated.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Rick Rothstein]

How about in E2 copied down & across

=TEXTJOIN(".",1,$B2,$D2,IF($D2=57600,"",E$1))

This formula would also work (even in versions of Excel that do not have the TEXTJOIN function)...

=$B2&"."&$D2&IF($D2=57600,"","."&E$1)

 

[Xirom431]

Thank you!! It is helpful to know.

 

[Xirom431]

Thanks Rick for your response.