Trim out last seven characters from a string...

[DubboPete]

Is this easy to do? The last seven characters are constants, I just
want what precedes them...

DubboPete

 

[Gary Keramidas]

give this a try

=MID(A1,1,LEN(A1)-7)

 

[DubboPete]

give this a try

=MID(A1,1,LEN(A1)-7)

--

Gary Keramidas
Excel 2003







- Show quoted text -

Just the ticket, thanks Gary!

 

[David Biddulph]

Or more simply
=LEFT(A1,LEN(A1)-7)