Text & Cell Reference in the same Cell
 

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

Text & Cell Reference in the same Cell
 

="Kindly debit our account # "&A1&" with $"&B1
or if you are fussy about the format of a particular entry, something like:
="Kindly debit our account # "&A1&" with $"&TEXT(B1,"#,##0;-#,##0")
--
David Biddulph

"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

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