Posted to microsoft.public.excel.misc

external usenet poster

Posts: 4

convert text string to a number code

I need to convert a list of text values and assign a number code
example:
Text Value Code
A- 7
A 6
A+ 5
AA- 4
AA 3
AA+ 2
AAA 1

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert a Number Code to a Text Code	Traye	Excel Discussion (Misc queries)	3	April 6th 07 09:54 PM
Convert a number to a name string	Numbers to name string	Excel Worksheet Functions	2	June 23rd 06 04:52 PM
Convert text strings to a code or number	MaxNY23	Excel Worksheet Functions	15	March 23rd 06 10:47 PM
How to COnvert text string to number	timtak	Excel Discussion (Misc queries)	3	June 4th 05 04:57 AM
convert string to number	Christina	Excel Worksheet Functions	3	November 16th 04 02:36 PM

All times are GMT +1. The time now is 06:41 AM.

About Us

"It's about Microsoft Excel"