I have large data running in row but in single column as follows :-
BELLA TRAVEL 17/34 Redmyre Rd Burwood NSW 5612 Phone:02 4567 1234 Fax: 02 4567 1111 Manager: King Wood Director: Paul Front Email: [email protected] Licence No: 4576
Member Eagle Business Group
Email: [email protected] Phone 02 7645 0956 Fax:7645 4455 Manager: Debbie Short
71 River St NSW 2034 Licence No: 76447956
I am tring to extract data for meaningful use by putting "Phone:" under Phone heading , "Fax:" under FAX heading, "Manager:" under Manager heading, and so for director, Emails and Licence number.
All data is very inconsistent but one thing is common company name are in uppercase and other details end with (semilcolon) :
lease see test2 file as ansample (Excel 2007)
Can you please edit functions?