Reply to thread

Message: [QUOTE="Willie, post: 14121529"] I have a cell range (A1:A4) that contains the following information A1 When Assigned Organization is XYZ, change Assigned POC to Black, Jack, change Assigned Alt. POC to Doe, Jane, and change Substitute POC to White, Jack A2 When Assigned Department is X-A/7, change Assigned POC to Young, Jim, change Assigned Alt. POC to Brown, Frank, and change Substitute POC to Stewart, Rod A3 When Assigned Group is X-B (XMO/ABC), change Assigned POC to Simon, Paul, change Assigned Alt. POC to Bowie, David, and change Substitute POC to Miller, Steve A4 When Assigned Staff is Staffing Personnel (SP), change Assigned POC to Gates, David, change Substitute POC to Reed, Lou, and change Assigned Alt. POC to Gaines, Steve Note that the strings above are not always in the same order. Compare the POCs for A3 & A4 I need to split this cell range into several different columns. I need cells B1:B4 to contain the string of characters between “When” and “is”. For example, B1:B4 will contain the following: Assigned Organization Assigned Department Assigned Group Assigned Staff I need cells C1:C4 to contain the string of characters between “is” and the first “,”. C1:C4 will contain the following: XYZ X-A/7 X-B (XMO/ABC) Staffing Personnel (SP) D1:D4 will contain the “Assigned POC”. E1:E4 will contain the “Assigned Alt. POC” and F1:F4 will contain the “Substitute POC” Again, The POCs are not always in the same order... I’ve tried the RIGHT, LEFT, LEN and FIND functions but I can’t get the correct combination to solve this. Can anyone help? Thanks for your help in advance [/QUOTE]

Verification