add data in column C on to end data in col B

[leecavturbo]

hi chaps. got some data in column C that needs to be next to the data in column B or A if no data in B but seperated by a space. how can i do that? long column!

 

[VoG]

Try

=B1&" "&C1

and copy down.

 

[leecavturbo]

my bad i edited the post just after posting it!
did you see that vog?

 

[VoG]

Try

=IF(B1="",A1&" "&C1,B1&" "&C1)

 

[leecavturbo]

resolved

Thank you Peter