Thread: Copy middle digits from one cell into another
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bony_tony bony_tony is offline
external usenet poster
  
Posts: 76
Default Copy middle digits from one cell into another
Or =MID(A1,((LEN(A3)/2)-1),5) if the length of the characters varies.

Tony

On Jan 4, 8:08 am, Sharon R <Sharon
wrote:
I need a formula to copy the middle digits from one cell to another. i.e.
132sk215zb from Cell A1 and transfer only the 2sk215 into Cell D1. Can
anyone help?

Reply With QuoteReply With Quote