rolandeckstein
New Member
- Joined
- Aug 3, 2010
- Messages
- 24
Ok, so I have a cell that contains data in the following format:
John Smith (CEO); Warren Zevon (CFO); Pete Townsend (VP Operations)
I need to setup formulas so that in the first new column the cell would contain:
John Smith; Warren Zevon; Pete Townsend
And the second column would display the following:
CEO; CFO; VP Operations
Is there a way to selectively extract this data so that one column extracts whatever data is in Parenthesis and the other selects the data not in Parenthesis?
Any and ALL help is much appreciated
John Smith (CEO); Warren Zevon (CFO); Pete Townsend (VP Operations)
I need to setup formulas so that in the first new column the cell would contain:
John Smith; Warren Zevon; Pete Townsend
And the second column would display the following:
CEO; CFO; VP Operations
Is there a way to selectively extract this data so that one column extracts whatever data is in Parenthesis and the other selects the data not in Parenthesis?
Any and ALL help is much appreciated