Creating function using numbers & text

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
 
P

PCLIVE

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

=1 & " - website only"

HTH,
Paul
 
L

lucy

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

Gord Dibben

=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
 

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

Page numbering with Merged Document and IF statements 1
Excel - Wich Function should I use? 1
Excel does not accept text format! 0
Looking for Information Word (Office 365) editing using VB.Net 1
Modern equivalent of Autotext in Word? 0
Problems created by Recent updates to Outlook 365 0
Formating bolded text exclusively. 0
Link a text box based on drop down box with four options MS Word 365 0

Top