Convert Text Values to Specific Numeric Values

Hi,

I have a table with several columns of characteristics from a given marketing campaign. Ultimately I would like to measure each individual description characteristic against campaign success rates. I have determined that I must convert the text entries describing each characteristic into a numeric value. This is where I'm stuck. Can anyone help with this?

Hi
Just create a simple two column table of all description characteristics in one column and a numeric value alongside in the next column. Then use a VLOOKUP() function to lookup up the value in the table against the corresponding description.

HTH

I will give that a shot, thanks!!

the best code from ghasem76
ActiveSheet.Range("b5:b6004,g5:g6004").Select

For Each xCell In Selection
If IsNumeric(xCell) = False Then
' xCell.Value = CDec(xCell.Value)
xCell.Value = Val(xCell.Value)
Else
End If
Next xCell