All Hokie, All the Time. Period. Presented by

The Lounge Board

VTSnake

Joined: 10/07/2005 Posts: 4530
Likes: 1210


=LEFT(RIGHT(A1,7),6)


(In response to this post by Baltimore Hokie)

Posted: 12/12/2019 at 3:59PM



+0

Insert a Link

Enter the title of the link here:


Enter the full web address of the link here -- include the "http://" part:


Current Thread:
 
  
Excel question -- Baltimore Hokie 12/12/2019 3:38PM
  Use the delegate function. ** -- Guy LeDouche 12/12/2019 4:16PM
  Is that delegating the task to a subordinate? ** -- EDGEMAN 12/12/2019 4:21PM
  Does the text or numbers have any commonality? -- HokieDevil 12/12/2019 4:09PM
  =LEFT(RIGHT(A1,7),6) ** -- VTSnake 12/12/2019 3:59PM
  Or =MID(A1,2,6)** -- VTENGR 12/12/2019 4:25PM
  It works! ** -- VT Pez4Life 12/12/2019 4:12PM
  So the digits are inside parentheses? -- s.mill hokie 12/12/2019 3:47PM
  That did it, thank! ** -- Baltimore Hokie 12/12/2019 4:28PM
  Copy paste delete. Have fun ** -- HokieAl 12/12/2019 3:42PM

Tech Sideline is Presented By:

Our Sponsors

vm307