Creating function using numbers & text

  • Thread starter Thread starter lucy
  • Start date Start date
L

lucy

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
 
Not sure exactly what you mean, but maybe something like this.

=1 & " - website only"

HTH,
Paul
 
i will have text in each cell that could be different each time. So maybe I
am trying to do something that's impossible.
 
=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
 
Back
Top