Convert text to numeric value

D

Dylan @ UAFC

I wan to be able to convert a test code in one colum to
= a numeric value in another cell.
For example
PNI is a code that represent a value of $20.00
PS is a code that represents a value of $10.00
Ps would be entered into A1 and then converted to numeric value in cell f1
Please advise
 

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

general data convert to numeric. 1
HOW DO I CONVERT A NUMERIC IN WORDS? EG. 100 (ONE HUNDRED) 1
convert text format to numeric 5
Convert numeric values in words. 6
Count Numeric Value with condition 5
Validation numeric and text 4
Text string to Numeric string 1
Re : Numeric to alphbetical text 4

Top