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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select only certain characters from a cell.
assume your data is in cell A1
=Right(A1,4) would display Pump =Left(A1,6) & right(A1,4) would take out UNAGGLO -- Regards, Tom Ogilvy "SS" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select only certain characters from a cell.
If you meant only display characters 7 through 11 (7,8,9,10,11 is five
characters) =Mid(A1,7,5) but UNAGGLO is 7 characters, and this would only show UNAGG, so you could modify it to =Mid(A1,7,7) to display UNAGGLO -- Regards, Tom Ogilvy "SS" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
select only certain characters from a cell.
Ta.
|
Reply |
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 |