# excel 2007 HELP ME PLEASE!!

May 5, 2009 at 12:47:51
Specs: Windows XP
 Help me in trying to solve this problem that i been fighting with for 2 days. merging 2 columns into the 3rd with a 1 space between the infro in EXCEL 2003Example: F(AB1) & H(16g)=G(AB1 16g).

See More: excel 2007 HELP ME PLEASE!!

#1
May 5, 2009 at 13:00:36
 try:=F1&" "&H1There is a space between the two quotes.MIKEhttp://www.skeptic.com/

Report •

#2
May 5, 2009 at 13:04:48
 thanks for the answer so qiuckly and have tried that and for me an excel dummy it leaves the formula in the third column

Report •

#3
May 5, 2009 at 13:20:41
 I don't know what you mean?Your example:F(AB1) & H(16g)=G(AB1 16g).Cell F1 contains AB1Cell H1 contains 16gyou combine both cells with the formula =F1&" "&H1into Cell G1.MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
May 5, 2009 at 23:11:45
 Don't forget to type the "=" before the formula in the cell, then you will get the result.Mike's answer is perfect.EmmaHappy everyday~http://www.glaryutilities.com

Report •