Easy Question "I think" Text with funtions in it???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
="Reverse Check # " & Check_number_cell & " on " & Date_cel l& " from Account
" & Account_number _Cell
 
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
 
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
 
I got it, THANK YOU, my boss thought I'd be doing this for 3 more hours, took
me 20 minutes
 
Sorry not getting it can you write the exact formula again the way you did it
the first time??? PLEASE
 
It looks like the insert because it didn't do it after I changed my macro and
ran it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

holidays does not work properly in networkdays funtion. 4
Formula Question 2
Convert arabic number to english text 2
Ignore blank celss in left function 2
Formula with 2 conditions 2
=IF function, reference problem to "text strings" in Data Validati 2
i need a fuction 1
Date Question 7

Back
Top