Extract String from Text

LadyDi

Registered User.
Local time
Today, 03:29
Joined
Mar 29, 2007
Messages
894
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?
 
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.
 
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)))
 

Users who are viewing this thread

Back
Top Bottom