Thread: Splitting cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fazz fazz is offline
external usenet poster
  
Posts: 8
Default Splitting cells
in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns
Reply With QuoteReply With Quote