it would have been easier to help you if you had uploaded the sample file, rather than a picture (cant see your other formulas in a pic). however, when i want to join cells/text together, i prefer to use the & instead. so your formula (which btw, looks lie it should copy down and work fine) would be...
=G3&" "&C3&" "&D3&E3&" "&F3
try tha and let me know how you make out. if it doesnt work, please upload the actual sample file![]()
Bookmarks