0

I am having trouble pulling text from a cell that is a long web address. It varies in length but the text I'm after always follows &REQNO=. It's a number that looks like ABC-ABC-2015-0001. I would like to use Visual Basic for this and was trying the regex capabilities to no avail.

Wayne Conrad
  • 103,207
  • 26
  • 155
  • 191
DanosaurusRexx
  • 3
  • 1

1 Answers1

0

With data in A1, in another cell enter:

=MID(A1,FIND("&REQNO=",A1)+LEN("&REQNO="),9999)

enter image description here

Gary's Student
  • 95,722
  • 10
  • 59
  • 99
  • Thanks for your reply! It seems to work, but it is pulling the data after my string as well. Is there a way to cut it off after a certain amount of characters? – DanosaurusRexx May 06 '15 at 12:27
  • 1
    I fixed it, I changed the 9999 to 17 and it worked like a charm. Thanks for the quick reply! – DanosaurusRexx May 06 '15 at 12:30