the serial number will always be of constant string length .. hence easy to sort. But the name might not be two words always might vary from 1 to 4.There are actually two ranks. The first rank is the waitlist rank and the second rank is merit rank. and the difference between the two numbers is...
also i might give you an example :
Raw data
SR1234567 Stephen Hawking 123 231
SR1234568 Christopher Nolan 451 578
Now I want the SRXXXXXXX in one column, the name in one column and the two ranks in two different columns ...
i tried the text to column option but couldnt get it right...
well sorry if the title seems a bit misleading but i couldnt find a better one. My problem in excel is that there is a huge list of names and their corresponding ranks in pdf format. When I copy the data to excel sheet all data is shown in one column. Now the problematic part is taking out the...
hi..
i have data in four tabs and i want to print the data by using an ActiveX or form control button in a different tab...
im week in VBA programming so any help on this front will be appreciated :)
Regards
Ramakanth