Episode 157 – Break apart a column | Learn Excel from MrExcel

Episode 157 – Break apart a column

December 30, 2005 at 9:00 am Bill Jelen Leave a comment

Use the LEFT function to return just the left-most three characters from a column of values. Episode 157 will show you how.

This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!

Entry filed under: Uncategorized.

Episode 156 – Text Calculations in Excel Episode 158 – MID Function

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Trackback this post | Subscribe to the comments via RSS Feed

Recent MrExcel Tweets

Data From Picture is now in #Excel! Watch as I give it a spin: youtu.be/qZFvICmOb58tweeted at... 1 week ago

Could you help test #Excel file sharing? See if you can open this worksheet and add your first name to column A.… twitter.com/i/web/status/1…tweeted at... 1 week ago

RT @celia_excel: There's still time to join the MS Excel Toronto meetup group to learn from @OzExcel and @MrExcel about dealing with data…tweeted at... 1 week ago

I learned a lot from @OzExcel while collaborating on this 3rd edition of Guerrilla Data Analysis Using Microsoft Ex… twitter.com/i/web/status/1…tweeted at... 1 month ago

RT @MSPowerQuery: We recently added the Percentile operation to the Group by feature. What other operation would you like to see being adde…tweeted at... 1 month ago

Learn Excel from MrExcel