I have been given a mish-mash of data from a word doc that needs to be put into columns. See sample:
B, 01/20/15, 7:30am-10:30am, Conf Room ABC


CH 02/06/15, 7:30am-10:30a, 40ppl Pinard Foyer
B 02/18/15, 11:30am-2:30pm. 30ppl, Conf Room ABC
CH 2/23/15, 7:30am-10:30am, 40ppl SECC D
FH 3/07/15 7:30am-10:30am, 40ppl SECC B
B, 3/31/15, 7:30am-10:30am, 30ppl, Knowledge Room

Is there a way to edit/format this text without doing it line by line before running the Text to Columns?

Thank so much,
Maukford