Thread: Cell formatting question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
yshridhar yshridhar is offline
external usenet poster
  
Posts: 229
Default Cell formatting question
C1 your number
D1=left(c1,5)
best wishes
sreedhar

"ManhattanRebel" wrote:

I have 9 numeric characters in a cell and I need to get rid of the last 4.
How can I do that. There are too many cells to manually delete.
Reply With QuoteReply With Quote