teebird
Technical User
- Dec 11, 2001
- 239
I have one column of text that I want to separate the text into 4 columns.
Column 1 contains all the text including the date
16/03/2012; Issues Identified: high blood pressure Referral/Action: Sent to GP Problem List Updated? No Recalls added? Yes new recall for BP
Column 1 Issues Identified:
high blood pressure
Column 2 Referral/Action:
Sent to GP
Column 3 Problem List Updated?
No
Column 4 Recalls added?
Yes new recall for BP
Column 1 contains all the text including the date
16/03/2012; Issues Identified: high blood pressure Referral/Action: Sent to GP Problem List Updated? No Recalls added? Yes new recall for BP
Column 1 Issues Identified:
high blood pressure
Column 2 Referral/Action:
Sent to GP
Column 3 Problem List Updated?
No
Column 4 Recalls added?
Yes new recall for BP