L LadyDi Registered User. Local time Today, 03:29 Joined Mar 29, 2007 Messages 894 Sep 27, 2012 #1 Is there a formula that will look for a phrase (i.e. "Status bytes:") and then pull all characters between the : and the next space?
Is there a formula that will look for a phrase (i.e. "Status bytes:") and then pull all characters between the : and the next space?
G Galaxiom Super Moderator Staff member Local time Today, 20:29 Joined Jan 20, 2009 Messages 12,895 Sep 28, 2012 #2 Probably best write a custom function. It would not be very complex. Most of the coding will involve the InStr and Mid functions. Read up on them.
Probably best write a custom function. It would not be very complex. Most of the coding will involve the InStr and Mid functions. Read up on them.
NBVC Only trying to help Local time Today, 06:29 Joined Apr 25, 2008 Messages 317 Sep 28, 2012 #3 Is there a space right after the colon? If so, use: =LEFT(MID(A1,SEARCH("bytes:",A1)+7,255),FIND(" ",MID(A1,SEARCH("bytes:",A1)+7,255))) otherwise try: =LEFT(MID(A1,SEARCH("bytes:",A1)+6,255),FIND(" ",MID(A1,SEARCH("bytes:",A1)+6,255)))
Is there a space right after the colon? If so, use: =LEFT(MID(A1,SEARCH("bytes:",A1)+7,255),FIND(" ",MID(A1,SEARCH("bytes:",A1)+7,255))) otherwise try: =LEFT(MID(A1,SEARCH("bytes:",A1)+6,255),FIND(" ",MID(A1,SEARCH("bytes:",A1)+6,255)))