View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
DubboPete DubboPete is offline
external usenet poster
 
Posts: 30
Default 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!