array_deficient

Posts: n/a

how do I create an array

I have a column of values that look like: 00000000007310F0000

all cells are 19 chars in length, and the 15th char is alpha. I need to map
the 15th alpha char to a numeric. the mapping is as follows:

ABCDEFGHI (column F)
123456789 (column G)

this is where I'm at:
=REPLACE(C3,15,1,(IF(MID(C3,15,1)=({F3:F12}),({G3: G11}),"")))

please help

Reply With Quote

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
Create a Chart with Values from Array AND NOT from Ranges	syrhus	Charts and Charting in Excel	5	March 19th 05 02:37 AM
Entering array in single cell	nospaminlich	Excel Discussion (Misc queries)	6	February 11th 05 05:01 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM
Formula to list unique values	JaneC	Excel Worksheet Functions	4	December 10th 04 12:25 AM
VBA Import of text file & Array parsing of that data	Dennis	Excel Discussion (Misc queries)	4	November 28th 04 10:20 PM

All times are GMT +1. The time now is 11:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us