Creating function using numbers & text
 

I have created the function to add in my columns & rows. However, I have
descriptive text that I want to include in the cell. What would the function
be for this? EX: 1 - website only

Creating function using numbers & text
 

Not sure exactly what you mean, but maybe something like this.

=1 & " - website only"

HTH,
Paul

--

"lucy" wrote in message
...
I have created the function to add in my columns & rows. However, I have
descriptive text that I want to include in the cell. What would the
function
be for this? EX: 1 - website only

Creating function using numbers & text
 

Maybe

= A1+B1 & " Website only"

Substitute A1+B1 for your formula

Mike

"lucy" wrote:

I have created the function to add in my columns & rows. However, I have
descriptive text that I want to include in the cell. What would the function
be for this? EX: 1 - website only

Creating function using numbers & text
 

i will have text in each cell that could be different each time. So maybe I
am trying to do something that's impossible.

"PCLIVE" wrote:

Not sure exactly what you mean, but maybe something like this.

=1 & " - website only"

HTH,
Paul

--

"lucy" wrote in message
...
I have created the function to add in my columns & rows. However, I have
descriptive text that I want to include in the cell. What would the
function
be for this? EX: 1 - website only

Creating function using numbers & text
 

=A1 & " - website only"

Or do you mean the "- website only" is different?

Show us a sample of your data currently entered and what you want it to look
like after.


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 12:40:00 -0700, lucy wrote:

i will have text in each cell that could be different each time. So maybe I
am trying to do something that's impossible.

"PCLIVE" wrote:

Not sure exactly what you mean, but maybe something like this.

=1 & " - website only"

HTH,
Paul

--

"lucy" wrote in message
...
I have created the function to add in my columns & rows. However, I have
descriptive text that I want to include in the cell. What would the
function
be for this? EX: 1 - website only