Merging 2 cells

[riothecat]

I know I can merge 2 cells, I also know that by combining 2 cells it only keeps the info in the left most cell. is there a way to combine info in 2 different cells



A1 B1
AFG 1368

So that the numbers in a1 would combine (merge) with B1 and return a result of afg1368.

Thanks

[gebobs]

Try this in a third cell, like C1.

=a1&B1

[riothecat]

perfect. so simple is silly

[gebobs]

Haha...well that's how it goes sometimes.