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???
Place the date reference within a TEXT function. Something like:
TEXT(B1,"m/d/yy") You can pick whatever date format you wish. HTH, Elkar "Schwimms" wrote: Ok one more quick question. Its change the date to a number how do I make it stay at a date? "Elkar" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy Question "I think" Text with funtions in it???
I got it, THANK YOU, my boss thought I'd be doing this for 3 more hours, took
me 20 minutes "Elkar" wrote: Place the date reference within a TEXT function. Something like: TEXT(B1,"m/d/yy") You can pick whatever date format you wish. HTH, Elkar "Schwimms" wrote: Ok one more quick question. Its change the date to a number how do I make it stay at a date? "Elkar" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy Question "I think" Text with funtions in it???
Sorry not getting it can you write the exact formula again the way you did it
the first time??? PLEASE "Elkar" wrote: Place the date reference within a TEXT function. Something like: TEXT(B1,"m/d/yy") You can pick whatever date format you wish. HTH, Elkar "Schwimms" wrote: Ok one more quick question. Its change the date to a number how do I make it stay at a date? "Elkar" wrote: 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. |
#7
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. |
#8
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) |