Thread: use only the first 3 letters of cell data
View Single Post
  #1   Report Post  
N E Body
 
Posts: n/a
Default use only the first 3 letters of cell data
Hi everyone

I need to split data. A cell contains CHH05 and I need a formula that will
give a result of CHH.

Could someone suggest a solution?

TIA

Kenny
Win NT and 2000 with Office 97


Reply With QuoteReply With Quote