View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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