Hi All
I have a an exported set of Excel column headers with no-space text data in column C
The data in column C at the moment has to be manually separated
I need to separate the text with no spaces in one column into separated parts in order to run Pivot Tables
Here are some examples of the text in each cell in this column (about 800 rows) -
Absconded client:Whereabouts unknown
Medication:Error>wrong dosage
Missing person(s):Client missing>Whereabouts unknown
Behaviour:Self harm>Actual
Other:Motor Vehicle>Damage (accidental)>>minor
The text before the colon consists of the Category heading and will be placed into its own column - A
The text after the colon consists of the category detail type and will be placed into its own column - B
I have checked the Internet but have not found anything suitable – I am not an expert Excel user but only pedestrian
Is there a formula(s) or method which can extract the text as required please?
I have attached a file to show some of the data
Thank you for your help