| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need help creating a function that will extract words from a string of text | Excel Worksheet Functions | |||
| Creating a chart with text not numbers | Charts and Charting in Excel | |||
| does an IF function only look up numbers & not text? | Excel Discussion (Misc queries) | |||
| How do I set up an IF function with text and numbers? | Excel Worksheet Functions | |||
| numbers to text function | Excel Worksheet Functions | |||
Linear Mode
