Editing text before running text to columns

[maukford]

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

[thetraininglady]

Depends what type of formatting you want to apply?

[maukford]

Training Lady,
The text was emailed to me as a word doc and they would like it put in excel as columns. I have no problem copying it to excel and using the text to column function however, there is a lot of data that needs to have commas inserted, periods removed, dates standardized in order to sort them in excel. The sample I put in my original thread shows a few lines of the data that I received.
Thank you!

[Pecoflyer]

Could you please post a sample sheet? ( no pics pse) They are easier to work with and avoid having to re-type - Thx