How to use excel for building sql-syntax

i've got a table of names and their name inside a DB, it looks like this:

     A    |    B
1|  abc   | dbo.abc, 
2|  def   | dbo.def, 
3|  ghi   | dbo.ghi, 

i need them as xml objects like this

<Field name="abc" inDb="dbo.abc" />
<Field name="def" inDb="dbo.def" />
<Field name="ghi" inDb="dbo.ghi" />

in order to archive this i made up the excel-cells:

E1: <Field name="
F1: " inDb="
G1: " />

now for cell C1 i made this function:

=$E$1+A1+$F$1+B1+$G$1

but what i get is: #VALUE!

also it would be nice, if there was a way to chop everything behind and including the last ',' from my B-Column

any suggestions?