| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create an If Statement that will replace text
Can I create an If statement that will replace text with text. For example
can I write a statement that will do this If(F1=MJW, RGS, JDC). I have tried to use the text function and subsitute function but it is not working. Any helps or tips would be appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I create an If Statement that will replace text
=IF(F1="MJW","RGS","JDC")
put this is any other cell and it will display the result. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "kalikw" wrote in message ... Can I create an If statement that will replace text with text. For example can I write a statement that will do this If(F1=MJW, RGS, JDC). I have tried to use the text function and subsitute function but it is not working. Any helps or tips would be appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I create an If Statement that will replace text
try putting quotes around the text
-- Don Guillett SalesAid Software "kalikw" wrote in message ... Can I create an If statement that will replace text with text. For example can I write a statement that will do this If(F1=MJW, RGS, JDC). I have tried to use the text function and subsitute function but it is not working. Any helps or tips would be appreciated. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I create an If Statement that will replace text
It worked! Thanks so much Bob and Don for your help.
"Don Guillett" wrote: try putting quotes around the text -- Don Guillett SalesAid Software "kalikw" wrote in message ... Can I create an If statement that will replace text with text. For example can I write a statement that will do this If(F1=MJW, RGS, JDC). I have tried to use the text function and subsitute function but it is not working. Any helps or tips would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) | |||
| replace axis text with graphics on excel chart (excel 2003) | Charts and Charting in Excel | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| Replace ALT+ENTER from multiple text cell | Excel Discussion (Misc queries) | |||
Linear Mode
