| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Text from one cell as part of a cell reference in another | Excel Discussion (Misc queries) | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
| How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Linear Mode
