bobsacaman01
04-04-2011, 03:30 PM
Hi, I was wondering if anyone knows of a way to write a macro to be able to select every row that begins with a certain character. For instance "A" or "C". After each row that contains (for example "A") is selected I would then like to copy or cut and paste these instances into another word document.
This is a little off topic of my original post, but along those same lines... Some of the data I'm working with ends up on the next line. So is there a way to backspace (not sure if that's the correct word) every line that does not begin with said certain character, (for instance "A") to adjoin it on the previous row to make all the data matchup up with my orginial certain character?
Currently I'm going through and hitting backspace every place that doesn't contain "A" to get the runoff data back on the same row with the original string.
Hope this makes sense... the following is an example of the data I'm working with:
A 1 10 A37 Davis Hooper R . . . 3 AU40 Davis
Demario
A 2 7 A40 Davis Hooper R . . . 1 AU41 Byrd Najel
A 3 6 A41 Barrett Trotter P C Derek Winter 13
ASU46 AU Bates Graham
A 1 10 K46 Davis Hooper R . . . 6 ASU40 Draper Amos
A 2 4 K40 Davis Hooper R . . . 3 ASU37 Davis
Demario
A 3 1 K37 Davis Hooper R . . . 2 ASU35
AU Davis Demario Bates Graham
K 1 10 K22 Robertson Je R . . . 5 ASU27 Jessel
Curry Kenneth Carter
K 2 5 K27 Butterfield P P C Smith Andre 5
ASU32 ASU Eltoro Freeman
K 1 10 K32 Butterfield P P C McCants Carlos 11
the ASU43 ASU Chris Davis
K 1 10 K43 Lawson Derek R . . . 2 ASU45 Kenneth
Carter
K 2 8 K45 Butterfield P P C Smith Andre 14
the AU41 ASU
K 1 10 A41 Butterfield P P I Fleming RJ
K 2 10 A41 Butterfield P P C McCants Carlos 9
AU32 Chris Davis
K 3 1 A32 Robertson Je R . . . 0 AU32 Kenneth
Carter
K 4 1 A32 Robertson Je R . . . 3 AU29
ASU Mike McNeil
K 1 10 A29 Butterfield P P C Henderson L 6
AU23 Eltoro Freeman
K 2 4 A23 Robertson Je R . . . -1 AU24 T'Sharvan
Bell Nosa Eguae
K 3 5 A24 Butterfield P P I McCants Carlos QB hurry
by Jessel Curry QB hurry by Corey Lemonier
This is a little off topic of my original post, but along those same lines... Some of the data I'm working with ends up on the next line. So is there a way to backspace (not sure if that's the correct word) every line that does not begin with said certain character, (for instance "A") to adjoin it on the previous row to make all the data matchup up with my orginial certain character?
Currently I'm going through and hitting backspace every place that doesn't contain "A" to get the runoff data back on the same row with the original string.
Hope this makes sense... the following is an example of the data I'm working with:
A 1 10 A37 Davis Hooper R . . . 3 AU40 Davis
Demario
A 2 7 A40 Davis Hooper R . . . 1 AU41 Byrd Najel
A 3 6 A41 Barrett Trotter P C Derek Winter 13
ASU46 AU Bates Graham
A 1 10 K46 Davis Hooper R . . . 6 ASU40 Draper Amos
A 2 4 K40 Davis Hooper R . . . 3 ASU37 Davis
Demario
A 3 1 K37 Davis Hooper R . . . 2 ASU35
AU Davis Demario Bates Graham
K 1 10 K22 Robertson Je R . . . 5 ASU27 Jessel
Curry Kenneth Carter
K 2 5 K27 Butterfield P P C Smith Andre 5
ASU32 ASU Eltoro Freeman
K 1 10 K32 Butterfield P P C McCants Carlos 11
the ASU43 ASU Chris Davis
K 1 10 K43 Lawson Derek R . . . 2 ASU45 Kenneth
Carter
K 2 8 K45 Butterfield P P C Smith Andre 14
the AU41 ASU
K 1 10 A41 Butterfield P P I Fleming RJ
K 2 10 A41 Butterfield P P C McCants Carlos 9
AU32 Chris Davis
K 3 1 A32 Robertson Je R . . . 0 AU32 Kenneth
Carter
K 4 1 A32 Robertson Je R . . . 3 AU29
ASU Mike McNeil
K 1 10 A29 Butterfield P P C Henderson L 6
AU23 Eltoro Freeman
K 2 4 A23 Robertson Je R . . . -1 AU24 T'Sharvan
Bell Nosa Eguae
K 3 5 A24 Butterfield P P I McCants Carlos QB hurry
by Jessel Curry QB hurry by Corey Lemonier