Hi,
I am copying information into excel from a word doc. For some reason the information is not lining up correctly in excel when I paste it.
2 questions!
q1. is there a way to paste the information in so that the same information appears in the same column?

1 Jon Do G Harriers M/Snr 19.1
2 Rory H Engls Track Club M/Snr 20.03
3 Jenny Fahy Olympic Houses M/Snr 20.25
4 Labeta Dabela Limekeys A.C M/Snr 20.46

thats an example of a piece of my results. i would just want
1 Jon Do G Harriers M/Snr 19.1
2 Rory C Ennis Track Club M/Snr 20.03
3 Jenny Fahy Olympic Houses M/Snr 20.25
4 Labeta Dabela Limekeys A.C M/Snr 20.46

q2. if that cant be done, how can i highlight multiple columns and and merge the information into one column? eg.
change
col1 col2
M/Snr
M/Snr
M/Snr
M/Snr
M/Snr
M/Snr
M/Snr
M/35
M/Snr
M/Snr
M/Jnr
to
col1 col2
M/Snr
M/Snr
M/Snr
M/Snr
M/Snr
M/Snr
M/Snr
M/35
M/Snr
M/Snr
M/Jnr

thanks