Concatenate function

[stephaniex3]

Please help me with the following. Thanks a lot.

qn on concatenate.xls

[benishiryo]

hi stephaniex3. try putting your full text in another location & join them up. let's say this full text is in A24:

is due to two special occasions, GSS and Mother's Day that happened during this particular month. The is the result of children purchasing presents for their mothers on Mother's Day and since women prefer appealing and trendy apparels, this then makes apparels the most favourable option.

use:
="The "&A6&" in "&$A$5&A24