dchaney
Well-known Member
- Joined
- Jun 4, 2008
- Messages
- 732
- Office Version
- 2016
- Platform
- Windows
Hello All,
I am trying to figure this out, and have been struggling.
I am currently using a "For - Next" loop to cycle through rows in a spreadsheet. This code looks for a keyword ("SHELF") within column "I" and I need to pull back the number (1 - 6) that is 2 characters after this word in the cell (i.e - "C:D (SHELF 1, BIN 13) / B:V:U:Z (SHELF 5, BIN 4) / FRAME WASH"). This number is not always in the same location within the cell as the location data differs.
Does anyone know a way to get that data?
I am trying to figure this out, and have been struggling.
I am currently using a "For - Next" loop to cycle through rows in a spreadsheet. This code looks for a keyword ("SHELF") within column "I" and I need to pull back the number (1 - 6) that is 2 characters after this word in the cell (i.e - "C:D (SHELF 1, BIN 13) / B:V:U:Z (SHELF 5, BIN 4) / FRAME WASH"). This number is not always in the same location within the cell as the location data differs.
Does anyone know a way to get that data?