how can i show the contents of two (or more) cells in one cell? For example, if i have a column of first names and one of last names, can i write a formula that will pull from the first and last name from each column and put it into one cell?
Dave Peterson - 19 Oct 2003 23:36 GMT
=a1 & " " & b1
Is one way.
> how can i show the contents of two (or more) cells in one cell? For example, if i have a column of first names and one of last names, can i write a formula that will pull from the first and last name from each column and put it into one cell?

Signature
Dave Peterson
ec35720@msn.com