Split Vertically at 20′s – 1102 – Learn Excel from MrExcel

September 16, 2009 at 9:00 am Bill Jelen Leave a comment

Dak asks how to take a long cell entry and to split it into 20 character entries going down a column without using wrap text. Episode 1102 shows a couple of ways to solve the problem.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of 377 tips from the book!

About these ads

Entry filed under: Uncategorized. Tags: array formula, formula, MID.

Split Ideas – 1101 – Learn Excel from MrExcel Blank Row for Missing Dates – 1103 – Learn Excel from MrExcel

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

=$A2*B$1 for a multiplication table? Better trick using MMULT youtu.be/6upVr3gOMd4 From @excelisfun new CSE DVD: mrexcel.com/store/index.ph…tweeted at... 14 hours ago

Learn Excel - Multiplication Table with MMULT - Episode 1732: youtu.be/6upVr3gOMd4?a via @YouTubetweeted at... 14 hours ago

Learn Excel - Count Visible Cells Matching Criteria - Episode 1731: youtu.be/4NJ3bNj5X_0?a via @YouTubetweeted at... 1 day ago

Dueling Excel - Count Occurrences of Each Text - Podcast 1730: youtu.be/OTGUoqliGrA?a via @YouTubetweeted at... 4 days ago

Learn Excel - Count Cells Containing a Substring: Podcast #1728: youtu.be/vysU2Q2ncak?a via @YouTubetweeted at... 5 days ago

Learn Excel from MrExcel