Thread: Truncate
View Single Post
  #2  
Old November 18th, 2009, 08:04 PM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
 
Posts: 8,714
Default Truncate

=LEFT(A1,200)
--
David Biddulph

"Elizabeth" wrote in message
...
I've never used this function before and frankly read all the instructions
and still dont understand it. I have a customer that doesn't want more
than
200 characters in his field, presently there are many cells with over the
200. I was told by him to do this function, as a customer I didnt want to
keep asking anymore questions.

Is there a way someone can explain "as if Im 5" how to do this funcition?
Thank you so much