ReePrime
Blog DMC
MrExcel's Learn Excel #959 - Split Alt+Enter

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

MrExcel's Learn Excel #959 - Split Alt+Enter

B
Bill Jelen

82 Views • Feb 26, 2009

Description

Someone used Alt+Enter to enter three fields in hundreds of cells. How can this be broken into separate columns. In Episode 959, I discuss MID, CODE, CHAR, and SUBSTITUTE functions 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 the 377 tips from the book!

Keywords & Tags

#excel #business #accounting #spreadsheets #tutorial #technology #mrexcel #formula

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

00:05

[PDF] EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets

Mingdestiny

00:05

Read EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets

Boziek

09:14

How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel

Alonza Darrick

00:27

Read Excel 2007/ Excel Hacks: Los mejores trucos/ Tips Tools for Streamlining Your Spreadsheets

Antonia Olivo

01:26

How to Excel Delete Remove Duplicates and Duplicate Cells Data from Multiple Excel Spreadsheets

HotHotSoftware1

00:28

PDF Excel for Auditors Audit Spreadsheets Using Excel 97 through Excel 2007 Download Full Ebook

Reyna