How can I remove the numbers and space before the text?
For example:
1 ABAD, NASSER NARCISO
2 ABAPO, REY CLINT REDILLAS
3 ABAYAN, CHARISSE HONRADO
4 ABAŅO, JEFFREY AQUINO
5 ABELLO, CHITO LEONIDO
6 ABLAY, NERIEGRACE NIDEA
7 ABRIL, AGNES GAY ALIGAM
8 ACERDEN, JUSTINE ANN RECEDE
9 ADRIANO, BEE JAY HALOG
10 ADUCA, ARNOLD DEL ROSARIO
11 ADUNA, ERIC JOHN MILLER
12 AGAYON, ALFRED MARK RODRIGUEZ
13 AGSAWA, RYAN-JAY RICAMORA
14 AGUA, SALVADOR ZABALLA
15 AGUILA, CLARENCE JASPER CHANG
16 AGUILAR, JERICH REYES
17 AGUILAR, JEROME REYES
18 AGUILAR, MYLENE MULDONG
19 AGUILLON, PAUL SANTOS
20 AGUINALDO, MARLON RAMOS
There will be hundreds or thousands of rows which will be pasted to the first column.
Your help will be very much appreciated. Thanks in advance!
Bookmarks