Stefan from Sweden checks in with a much better way to do a word count of all the sentences [referring to the "Word Count from Sentences" Podcast, Episode #1460]. How? Using... a tiny little Add-In that most Excel Users already have!
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel, episode 1462.
Word Count with Word.
Hey! Welcome back, this is Bill Jelen from MrExcel.
Got an email from Stephan.
Stephan saw the episode 1460, just a couple of days ago.
Where I try to get a word count from all of these sentences.
Check this out.
That's a pretty wild, [ control shift down arrow ], [ CtRL C ], to copy and then we're going to switch over to this little add-in, you probably have the add-in.
It's called Word, for people that can't seem to detect their letters in Excel.
I'm gonna paste to Word and then let's [ ctrl home ] and we're going to do [ ctrl H ] for find and replace.
Replace our recurrence of a [ space ] with Carrot P (^P).
That says change every space to a return, replace all.
All right! Now, that takes all of those words and puts them all into one big column.
It isn't that cool, that required three or four minutes of cut and paste for me let's do [ ctrl A ], to get them all again and then here check this out convert to lowercase, that prevents the whole having to use lower.
[ CtrL C ] to copy will switch back to the thing we know and love that's Excel.
I'll go to a new sheet, [ Ctrl V ] to paste.
Just put words up here as the heading.
Now, insert pivot table.
Okay!
Words in row labels and count awards in values, and we are good to go a lot faster than that thing, I did on Monday.
So, I will concede this one on MrExcel.
You will hardly ever hear me say this word made that easier.
Thanks to Stefan for sending that.
Brilliant idea and thanks to Zack for the original question.
And thanks to you for stopping by, we'll see you next time for another netcast from MrExcel.
Learn Excel from MrExcel, episode 1462.
Word Count with Word.
Hey! Welcome back, this is Bill Jelen from MrExcel.
Got an email from Stephan.
Stephan saw the episode 1460, just a couple of days ago.
Where I try to get a word count from all of these sentences.
Check this out.
That's a pretty wild, [ control shift down arrow ], [ CtRL C ], to copy and then we're going to switch over to this little add-in, you probably have the add-in.
It's called Word, for people that can't seem to detect their letters in Excel.
I'm gonna paste to Word and then let's [ ctrl home ] and we're going to do [ ctrl H ] for find and replace.
Replace our recurrence of a [ space ] with Carrot P (^P).
That says change every space to a return, replace all.
All right! Now, that takes all of those words and puts them all into one big column.
It isn't that cool, that required three or four minutes of cut and paste for me let's do [ ctrl A ], to get them all again and then here check this out convert to lowercase, that prevents the whole having to use lower.
[ CtrL C ] to copy will switch back to the thing we know and love that's Excel.
I'll go to a new sheet, [ Ctrl V ] to paste.
Just put words up here as the heading.
Now, insert pivot table.
Okay!
Words in row labels and count awards in values, and we are good to go a lot faster than that thing, I did on Monday.
So, I will concede this one on MrExcel.
You will hardly ever hear me say this word made that easier.
Thanks to Stefan for sending that.
Brilliant idea and thanks to Zack for the original question.
And thanks to you for stopping by, we'll see you next time for another netcast from MrExcel.
