Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and replace
How do I assign a numeric value to text entries on my data sheet?
For example, several codes are EX, VG, U, DS, FR, A and their respective numeric values are 5, 4, 3, 2, 1, 0. Wherever there's a "DS" on the data sheet, I'd like the number "2" substituted. I understand this was a "Search and replace" command in Excel 2003 (which I never used)... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and replace
You are correct:
Edit Replace and enter DS in the findwhat field and 2 in the replacewith field -- Gary''s Student - gsnu200763 "CatPEG" wrote: How do I assign a numeric value to text entries on my data sheet? For example, several codes are EX, VG, U, DS, FR, A and their respective numeric values are 5, 4, 3, 2, 1, 0. Wherever there's a "DS" on the data sheet, I'd like the number "2" substituted. I understand this was a "Search and replace" command in Excel 2003 (which I never used)... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and replace
Should also check "Match Case",
or things may happen to roads kids rounds If the above are upper case, you'll still have "things" happening.<bg -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gary''s Student" wrote in message ... You are correct: Edit Replace and enter DS in the findwhat field and 2 in the replacewith field -- Gary''s Student - gsnu200763 "CatPEG" wrote: How do I assign a numeric value to text entries on my data sheet? For example, several codes are EX, VG, U, DS, FR, A and their respective numeric values are 5, 4, 3, 2, 1, 0. Wherever there's a "DS" on the data sheet, I'd like the number "2" substituted. I understand this was a "Search and replace" command in Excel 2003 (which I never used)... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and replace
thanks...now the problem is with variable cominations, the formula interprets
half the variable. For example, "D" is 2, D-M is 2.4, M is 3. So, when I replace D with 2, the formula replaces every D including the D-M (shows it as 2-M). I've tried replacing D-M first, but same problem. "Gary''s Student" wrote: You are correct: Edit Replace and enter DS in the findwhat field and 2 in the replacewith field -- Gary''s Student - gsnu200763 "CatPEG" wrote: How do I assign a numeric value to text entries on my data sheet? For example, several codes are EX, VG, U, DS, FR, A and their respective numeric values are 5, 4, 3, 2, 1, 0. Wherever there's a "DS" on the data sheet, I'd like the number "2" substituted. I understand this was a "Search and replace" command in Excel 2003 (which I never used)... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and replace
Huh?
"Ragdyer" wrote: Should also check "Match Case", or things may happen to roads kids rounds If the above are upper case, you'll still have "things" happening.<bg -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Gary''s Student" wrote in message ... You are correct: Edit Replace and enter DS in the findwhat field and 2 in the replacewith field -- Gary''s Student - gsnu200763 "CatPEG" wrote: How do I assign a numeric value to text entries on my data sheet? For example, several codes are EX, VG, U, DS, FR, A and their respective numeric values are 5, 4, 3, 2, 1, 0. Wherever there's a "DS" on the data sheet, I'd like the number "2" substituted. I understand this was a "Search and replace" command in Excel 2003 (which I never used)... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and Replace | Excel Worksheet Functions | |||
Search and replace | Excel Worksheet Functions | |||
Search and Replace | Excel Discussion (Misc queries) | |||
Search and Replace | New Users to Excel | |||
Search and replace | Excel Worksheet Functions |