| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling a Letter from a cell and filling another cell with info
I am a newbee at this so bare with me......
Here is what I am trying to do with no luck so far. If I type RS23U1R109000 in a cell A1, I want B1 to read the 5th letter or number and fill B1 with E86. Example A1= RS23U1R109000 B1=E86 A1= RS23V1R109000 B1=E87 A1= RS23R1R109000 B1=E84 As you can see in my example, the 5th letter could be U,V,R or whatever, but I need cell B1 to read that letter and populate B1 with E86, E87, E84 or whatever. I hope I haven't confused anyone... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling cell with color using barcode scanner | Excel Discussion (Misc queries) | |||
| filling information from one cell and filling another. | Excel Worksheet Functions | |||
| Copying and Filling Cell With Functions | Excel Discussion (Misc queries) | |||
| filling a cell | New Users to Excel | |||
| how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) | |||
Threaded Mode
