| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace Formatted Cell Contents
Sorry, not too clear. Try again:
Some cells contain data like 13640681, formatted Special, SSN. Some files contain data like 013-64-0681. These variants may occur for the same individual. I need to sort the data to bring all of any individual's records together, hence I need to convert all of one kind or the other to a format that makes them all formatted the same. I hope that's a bit clearer! -- Dave Temping with Staffmark in Rock Hill, SC "Dave Birley" wrote: I have some mixed data formatting in a column, SSN. Some of it is in the format Numeric, then formatted 000-00-0000, and some of it is in the Format "123-45-6789". I need to make it all alike -- how do I proceed? -- Dave Temping with Staffmark in Rock Hill, SC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace #VALUE! with contents of cell?? | Excel Worksheet Functions | |||
| REPLACE PART OF CELL WITH FORMATTED TEXT | Excel Worksheet Functions | |||
| I need help writing a macro to replace cell contents. (new to VB) | Excel Programming | |||
| replace cell contents | Excel Worksheet Functions | |||
| How do I replace the contents of a cell with its value instead of. | Excel Worksheet Functions | |||
Threaded Mode
