Short Cut for Text to Column Wizard will help convert the text to number
Shortcut - ALT + A + E (any Version) there after checkbox delimit (by default the same is already check boxed) and press enter thrice
Many a times when we copy or download data from some data base in Excel we get something like this:
Here the number is stores as text which doesn't allow to use vlookup or search option on the same. To get rid of the same the above mentioned Shortcut can be used after selecting the entire column or row something like this:
Click Next and Finish the Task, What you will get after this will look like something like this;
Happy Reading!!!!
Shortcut - ALT + A + E (any Version) there after checkbox delimit (by default the same is already check boxed) and press enter thrice
Many a times when we copy or download data from some data base in Excel we get something like this:
Here the number is stores as text which doesn't allow to use vlookup or search option on the same. To get rid of the same the above mentioned Shortcut can be used after selecting the entire column or row something like this:
Click Next and Finish the Task, What you will get after this will look like something like this;
Happy Reading!!!!
E Learning Microsoft Office: Shortcut For Text To Column >>>>> Download Now
ReplyDelete>>>>> Download Full
E Learning Microsoft Office: Shortcut For Text To Column >>>>> Download LINK
>>>>> Download Now
E Learning Microsoft Office: Shortcut For Text To Column >>>>> Download Full
>>>>> Download LINK 4K