| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy Question "I think" Text with funtions in it???
Hi,
I would like to have a function that makes a cell say this ... Reverse Check # (a function that references the check) on (a function that pulls a date) from account (a funtion that pulls the account number). All this information that is needed to be referenced to is located in the spreadsheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy Question "I think" Text with funtions in it???
="Reverse Check # " & Check_number_cell & " on " & Date_cel l& " from Account
" & Account_number _Cell "Schwimms" wrote: Hi, I would like to have a function that makes a cell say this ... Reverse Check # (a function that references the check) on (a function that pulls a date) from account (a funtion that pulls the account number). All this information that is needed to be referenced to is located in the spreadsheet. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy Question "I think" Text with funtions in it???
Place the text portions of your formula in double-quotes. Then use the &
symbol to combine the different portions of your formula. Something like this: ="Reverse Check # "&A1&" on "&B1&" from account "&C1&"." This assumes your Check # is stored in A1, your date is stored in B1, and your account number is stored in C1. Adjust the references as needed. HTH, Elkar "Schwimms" wrote: Hi, I would like to have a function that makes a cell say this ... Reverse Check # (a function that references the check) on (a function that pulls a date) from account (a funtion that pulls the account number). All this information that is needed to be referenced to is located in the spreadsheet. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy Question "I think" Text with funtions in it???
Awesomeness thanks guys!
"Schwimms" wrote: Hi, I would like to have a function that makes a cell say this ... Reverse Check # (a function that references the check) on (a function that pulls a date) from account (a funtion that pulls the account number). All this information that is needed to be referenced to is located in the spreadsheet. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy Question "I think" Text with funtions in it???
It looks like the insert because it didn't do it after I changed my macro and
ran it. "Schwimms" wrote: Hi, I would like to have a function that makes a cell say this ... Reverse Check # (a function that references the check) on (a function that pulls a date) from account (a funtion that pulls the account number). All this information that is needed to be referenced to is located in the spreadsheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Easy Question "I think" Text with funtions in it??? | Excel Discussion (Misc queries) | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| How do I find ""Easy Sum" Not Auto Sum | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
