Thread: Separating Text in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default Separating Text in Excel
=RIGHT(A1,21)
--
Brevity is the soul of wit.


"Excel Help Needed" wrote:

Each line is in one cell, but all in column A. But I need to cut off the
charaters at 20 and move characters 21-26 into column B. How do I do it?

Reply With QuoteReply With Quote