How do i extract all the nos and put them in one column easily.
2006-08-22 18:23:17 · 4 answers · asked by dreamweaver 2 in Computers & Internet ➔ Software
OK. first things first.
Make a copy of the original and keep it aside so you wont mess up with data.
Now you have the copy you made. Open that. Select all the data on the sheet using ctrl-C.
Open a text editor, not notepad. Some other better ones like Textpad or ultra-edit or editplus.
Open a file and paste everythin on that.
The data in different cells will copy in line by line manner.
Remove any whitespaces and You have everything in line by line order. Now copy everything again from text editor and open a new excel sheet.
Place cursor on the first cell and paste into the sheet.
Then rock and roll :)
2006-08-22 18:30:09 · answer #1 · answered by Narend 2 · 0⤊ 0⤋
Are the correct numbers - still with the correct names? You can sort the entire spreadsheet. I was doing that and accidentally just sorted the names, so now I have alot of numbers by other ppl's names. The only way to fix that is to call them all and figure out who is who. LOL!
2006-08-23 01:29:03 · answer #2 · answered by Answer Me This 2 · 0⤊ 0⤋
It is a general question, the answer depends on the conditions
If the above answers not good enough, we can do a formula to do this.
mail me some more info and we can start
Read my profile, I am XLMan
2006-08-26 04:53:56 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Your question got the answer with it.
"Extract"
use the extract wizard and search for numbers.
Then use them according to your requirements.
2006-08-23 02:04:03 · answer #4 · answered by Ω Nookey™ 7 · 0⤊ 0⤋