Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select only certain characters from a cell.
I have a cell with something like
NT7230UNAGGLOPUMP I want another cell to read this one but only take out the UNAGGLO bit of it. IE only characters 7 through 11. I want another cell to take only the last 4 characters and thus display PUMP. how can I do this?? SS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
How do you select multiple characters in a drop down list to appe. | Excel Worksheet Functions | |||
copy select characters from specified cells. | Excel Worksheet Functions | |||
select a string of characters | Excel Worksheet Functions |