ReePrime
Blog DMC
Learn Excel - "Left 26, Even If Only 10": #1463

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

Learn Excel - "Left 26, Even If Only 10": #1463

B
Bill Jelen

45 Views • Nov 07, 2011

Description

Shrikant needs to join the left 26 characters of column A with column B. But...even if A2 only has 10 characters, he needs it to fill with spaces each and every time. In Episode #1463, Bill shows us how to maintain this positioning of data.

Keywords & Tags

#2010 accounting Bill Jelen business Excel formula Functions MrExcel spreadsheets technology tutorial Worksheet

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

07:27

Excel For Beginners | Functions (spreadsheets) HD

Junior Lexus

02:31

How to print multiple excel spreadsheets (& worksheets) at once

HotHotSoftware1

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

00:31

Read F1 Get the Most Out of Excel Formulas Functions: The Ultimate Excel Formulas Functions

IvetteStpierre

09:14

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

Alonza Darrick