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
|