M
merrymeet2u
some one please help!!!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
how do i add 2 columns to make the answer apper on the 3rd column
D
darkwood
I'm not sure if you are providing enough information for an accurat
answer, but I'd start out by saying: in C1 =SUM(A1+B1) and drag dow
column C
answer, but I'd start out by saying: in C1 =SUM(A1+B1) and drag dow
column C
B
Bob Phillips
just need
=A1+B1
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
=A1+B1
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
B
Bernard Liengme
Why the SUM function when =A1+B1 works just as well!
V
VinceM
If you want to combine text cells such as first & last name, if first name is
in B4 & last name is in C4, place your cursor in the cell where you want
combined info & use the function =B4&" "&C4 (if you want last name first then
a comma then first name, use =C4&", "&B4. You can combine numerous cells
this way, ie. =B4&" "&C4&" "&D4" " &E4. use the " " marks to place a space,
dash, or any other character between combined cells
Hope this helps
in B4 & last name is in C4, place your cursor in the cell where you want
combined info & use the function =B4&" "&C4 (if you want last name first then
a comma then first name, use =C4&", "&B4. You can combine numerous cells
this way, ie. =B4&" "&C4&" "&D4" " &E4. use the " " marks to place a space,
dash, or any other character between combined cells
Hope this helps