View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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