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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Schwimms - 17 Aug 2007 01:45 GMT

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 to this Message

bj - 17 Aug 2007 01:53 GMT

="Reverse Check # " & Check_number_cell & " on " & Date_cel l& " from Account
" & Account_number _Cell

> Hi,
>
[quoted text clipped - 5 lines]
> All this information that is needed to be referenced to is located in the
> spreadsheet.

Reply to this Message

Elkar - 17 Aug 2007 01:53 GMT

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

> Hi,
>
[quoted text clipped - 5 lines]
> All this information that is needed to be referenced to is located in the
> spreadsheet.

Reply to this Message

Schwimms - 17 Aug 2007 02:14 GMT

Awesomeness thanks guys!

> Hi,
>
[quoted text clipped - 5 lines]
> All this information that is needed to be referenced to is located in the
> spreadsheet.

Reply to this Message

Schwimms - 31 Jan 2008 21:56 GMT

It looks like the insert because it didn't do it after I changed my macro and
ran it.

> Hi,
>
[quoted text clipped - 5 lines]
> All this information that is needed to be referenced to is located in the
> spreadsheet.

Reply to this Message