Auto Populate Cells, can someone explain this

slick225 · Feb 25th 2005

My department is using an excel file to generate an XML file, and the formula used, I would like to use in other potential excel projects, could someone please explain this formula?

Sample Formula: Cell 1: =" Can Someone " &Cell 2 &" help me with this"
Cell 2: Please

The formula replaces the Cell reference in Cell 1 with what ever value is in Cell 2.

Please see sample file for a better example.

**Andy Pope** · Feb 25th 2005

Re: Auto Populate Cells, can someone explain this

Hi slick225,

The &'s are performing a concatenate operation.
The static text is joined with the contents of the cell reference placed in the middle.

"Join test text " & A1 & " with this text"

Anonymous · Feb 25th 2005

Re: Auto Populate Cells, can someone explain this

The & is a connector that concatenates what's before it with what's after it. As with any other formula in Excel, if there is a reference to a cell then the cell's contents are used. Does this help?

slick225 · Feb 25th 2005

Re: Auto Populate Cells, can someone explain this

Thanks Andy and Derk, that explained it all.
I've applied the formula to a few other projects and with some teaking it should work perfectly.

Thanks again.

Auto Populate Cells, can someone explain this

Participate now!

Share