Hi,
I have a sheet with a lot of rows of data such as:
<colgroup><col></colgroup><tbody>
</tbody>
I have a sheet with a lot of rows of data such as:
Hotel > Level 3 > Room 360 > Courtyard K 4 > Work-Complete |
Hotel > Level 3 > Room 360 > Courtyard K 4 > Work-Complete |
Hotel > Level 3 > Room 358 > Courtyard K 4A-HI.C > Work-Complete |
Hotel > Level 3 > Room 354 > Courtyard K 10 > Work-Complete |
Hotel > Level 3 > Room 349 > Courtyard K 5.S > Work-Complete I need to identify the room numbers in a separate cell, i.e. after the work "Room". I only want to return the numeric value. Room numbers are 3 or 4 digits. Anyone have any good ideas? Thanks! |
<colgroup><col></colgroup><tbody>
</tbody>