View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
casey casey is offline
external usenet poster
 
Posts: 80
Default How do I limit characters in a cell?

I have a cell with this information: "1234_01_251225". I need to have a
formula that will only give me the first 4 characters "1234". Is there a way
to do this? I need to add the formula to the entire column of data, since I
have thousands of rows of data.