Trim out last seven characters from a string...
On Feb 2, 3:04*pm, "Gary Keramidas" wrote:
give this a try
=MID(A1,1,LEN(A1)-7)
--
Gary Keramidas
Excel 2003
"DubboPete" wrote in message
...
Is this easy to do? * The last seven characters are constants, I just
want what precedes them...
DubboPete- Hide quoted text -
- Show quoted text -
Just the ticket, thanks Gary!
|