| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change text in cell
Hello,
I have a worksheet with a column containing data in the format "###########" I would like to change the values so that I can insert "dashes" at specific locations, such as "##-####-####-#" for all the values in the column. I tried the simple way...formating the cells, but when I run a formula, the values don't match and I get an error, unless the dashes are actually inserted. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change cell text colour based on value in other cell | Excel Worksheet Functions | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| How do I change replace text in a cell for different text? | Excel Worksheet Functions | |||
| How to change cell text based on another selected cell? | Excel Discussion (Misc queries) | |||
| Change text on one cell based on text in another | Excel Discussion (Misc queries) | |||
Threaded Mode
