All Hokie, All the Time. Period. Presented by

The Lounge Board

s.mill hokie

Joined: 04/19/2004 Posts: 6975
Likes: 799

What's this?

So the digits are inside parentheses?


If the six digits are inside parentheses, use this (replacing A1 for whatever cell):

=MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,LEN(A1))


If they aren't, could you just use the RIGHT function?

=RIGHT(A1,6)

(In response to this post by Baltimore Hokie)

Link: Extract between two characters


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


+0

Insert a Link

Enter the title of the link here:


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


75
Hide This

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
  Are all of the characters in the text string numbers? Basically you have.. -- EDGEMAN 12/12/2019 3:45PM
  Copy paste delete. Have fun ** -- HokieAl 12/12/2019 3:42PM

Tech Sideline is Presented By:

Our Sponsors







vm307