On Tuesday, 19 September 2017 23:21:46 UTC+5:30, GARYWC wrote:
Using your formula:

the formula in R5 changes to =A6&" "&B6&" "&C6
instead of staying =A5&" "&B5&" "&C5


Hi,

Try this,

=$A$5&" "&$B$5&" "&$C$5