Help combining values with a space between

[Brian]

Howdy All,

I am wondering if someone can help me with this one.

I have values in columns A and B.
The values are numeric.
I need to have the value combined into column C with a space between them.

Example.

A1 = 12345
B1 = 98

C1 must be 12345 98

Thanks,
Brian

 

[Roger Govier]

hi Brian

=A1&" "&B1

Regards

Roger Govier

 

[Ruffed Grouse]

Try this in C1:

=A1&" "&B1

 

[Brian]

Thanks very much!!!

Exactly what I needed.