Text & Cell Reference in the same Cell
Try this........
="Kindly debit our account # 1234456 with $"&G14
Vaya con Dios,
Chuck, CABGx3
"Deezel" wrote in message
...
Hello there,
I have spreadsheet that contains a directive to the various banks for
settling funds in our company.
there are a number of values and the text as well.
Eg. the cell contains this text
Kindly debit our account # 1234456 with $123,456 (this value is added
somewhere on the spreadsheet by a sum function I want this to be appended
in
the same cell with the text.
Please help
|