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.