Need to extract information after a certain word IE: "ROOM:"

[VJKOSHY]

Hello,
I'm new to this. Could someone help me with a formula i can use to extract to cell the room name/number from a text field. (I have several 100 of these i need to pull out to a separate cell) -

-----------------------
Example:
ISSUE: PROJECTOR NOT WORKING
Additional Info: have tech go to the site to replace the lamp and check the projector. Lamp will be supplied by the customer.
ROOM:RON- Training Room


ONSITE POINT OF CONTACT: BANK// 123-555-5314
POC EMAIL: Banks@noemail.com


ESC999599
CASE: 321-550500
-----------------------

 

[FDibbins]

You have shown 1 example of what you have (more examples would be better) but you have not said what you want or shown what you expect?

 

[VJKOSHY]

Thanks for the help- I'd like to pull out the "ROOM:" data out of each of these into a separate cell if possible.

More Examples:
---------------------------------------------------------------------------------------------------
ISSUE: PROJECTOR NOT WORKING


Additional Info: have tech go to the site to replace the lamp and check the projector. Lamp
will be supplied by the customer.


ROOM:RON- Training Room






ONSITE POINT OF CONTACT: BANK 1 // 631-555-1234




POC EMAIL: A.Bank@one.com




ESC99991
CASE: 327-123456






SO:


FST:DANNY YIM


RSC/SA: MCDANIELS
---------------------------------------------------------------------------------------------------
ISSUE: Need PARTS ORDERED - X19257-585-WC




ROOM: WC4-2145






ONSITE POINT OF CONTACT: R EWIN//804-555-1234 /CELL: 804-555-7221


POC EMAIL: R.Ewin@one.com






ESC99992
CASE:112-654321




SO:


FST:NONE


RSC/SA:MCDANIELS


inv#5651111


---------------------------------------------------------------------------------------------------
ISSUE: one of the drop-down mic is not working


Additional Info: They will definitely need a ladder to check the mic extender and wiring in the ceiling. The tech that was there the other day said it may be the incorrect cable - the tech should bring the correct crossover to daisy chain the 2 mics in case that is the issue




ROOM: ATRM-3-1006 -Team Stand-up room (West)






ONSITE POINT OF CONTACT: PMosely//847.555.1656 (office)// 630.555.0753 (cell)


POC EMAIL: pmosely@one.com






ESC999923
CASE:112-987654




SO:456123


FST: B EDWARD


RSC/SA:MCDANIELS


---------------------------------------------------------------------------------------------------
ISSUE: PLACE CAB COOL IN CRDENZA


ROOM:SF-Adaptive Path Knockout Conference






ONSITE POINT OF CONTACT: N.ERES// 408.555.6655


POC EMAIL: N.Eres@one.com


ESC99985
CASE: 112-566123






SO:345678
PO:876543


FST:NONE


RSC/SA: MCDANIELS


---------------------------------------------------------------------------------------------------
ISSUE: Screen does not get an image on it.




ROOM: MCL-1318


POC
NAME: E Weine //Mobile: 410-555-0187 | Desk: 703-555-1213


POC EMAIL: E.Weine@one.com




ESC99514
CASE:112-569623


SO:


FST: PHONE SUPPORT


RSC/SA:MCDANIELS


---------------------------------------------------------------------------------------------------
ISSUE: CONTROL PANEL NOT RESPONSIVE an RMA on this??


ROOM: WC1-4117


ONSITE
POINT OF CONTACT:R Ewin// Mob: 804-555-7221 //: 804-555-8477
POC
EMAIL: R.Ewin@one.com




ESC99123
CASE: 332-564567


SO:


FST: PHONE


RSC/SA:MCDANIELS
---------------------------------------------------------------------------------------------------