| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing none text entry to text?
Hello all
I hope you can help me. I have imported a worksheet from another source within this worksheet certain cells contain --:-- I want to create a formula to change this cell contents to NCO whats the best way of achieving this??? -- Many Thanks Ross |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing none text entry to text?
Look at Edit=Replace
Find What : --:-- Replace with: NCO HTH "Ross" wrote: Hello all I hope you can help me. I have imported a worksheet from another source within this worksheet certain cells contain --:-- I want to create a formula to change this cell contents to NCO whats the best way of achieving this??? -- Many Thanks Ross |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto text entry | Excel Discussion (Misc queries) | |||
| text entry | Excel Discussion (Misc queries) | |||
| Use custom format to add text to a text entry. | Excel Worksheet Functions | |||
| Text entry help | Excel Discussion (Misc queries) | |||
| Long Text Entry | Excel Discussion (Misc queries) | |||
Hybrid Mode
