| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Field
I have a spreadsheet that has about 1 thousand records. This spreadsheet has a field called StudyID that should have 3 digit numbers. Unfortunately there are some StudyID's in this field that are not 3 digit and I want to create a macro that can run through this spreadsheet to change these specific StudyID codes to the following correct StudyID. Thanks for your help
"8298" should be "857" "9052" should be "857" "10-002" should be "301" "191-5-0045-6" should be "954" "ALEXANDRA" should be "595" "FAM-028" should be "939" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Field Formatting in Pivot Tables | Excel Discussion (Misc queries) | |||
| Conditional formatting for a PivotTable field | Excel Discussion (Misc queries) | |||
| Formatting Date Field | Excel Discussion (Misc queries) | |||
| Formatting Charts according to field heading | Charts and Charting in Excel | |||
| Time Field Formatting | Excel Worksheet Functions | |||
Linear Mode
