Text & Cell Reference in the same Cell

[Deezel]

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

 

[David Biddulph]

="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")

 

[CLR]

Try this........

="Kindly debit our account # 1234456 with $"&G14

Vaya con Dios,
Chuck, CABGx3