Search and replace

  • Thread starter Thread starter CatPEG
  • Start date Start date
C

CatPEG

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)...
 
You are correct:

Edit > Replace and enter DS in the findwhat field and 2 in the replacewith
field
 
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>
 
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.
 
Huh?

Ragdyer said:
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>
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting multiple data codes to numbers 1
Search and add 3
Search and replace 2
Find and Replace based on neighboring cells? 4
Replace many asterisk characters, '*' in Excel 4
Find and Replace variable string 11
lookup for a value in multiple columns and return a result 16
LJ III pickup roller replacement? 4

Back
Top