Split a column of names in Excel 2003

Tim Smith 2010-10-01

Views 139

It’s common to use one column for names in a spreadsheet but this can cause problems if you want to sort by surname. Excel can convert the names into separate columns by using the space between them. Read more at www.computeractive.co.uk/2269564
Show more

Share This Video


Download

  
Report form
RELATED VIDEOS
How to Convert TEXT TO COLUMNS in Excel | Split Text into Multiple Columns in Excel in HIndi - AlamHindiGuide
play
06:13

How to Convert TEXT TO COLUMNS in Excel | Split Text into Multiple Columns in Excel in HIndi - AlamHindiGuide
How to Combine First Middle and Last Names into Full Names in Microsoft Excel
play
04:29

How to Combine First Middle and Last Names into Full Names in Microsoft Excel
Extract First Middle and Last Names from a list of Names in Microsoft Excel 365
play
00:50

Extract First Middle and Last Names from a list of Names in Microsoft Excel 365
MS Excel _ Split text into multiple columns _ Sorting and Filtering Data
play
12:17

MS Excel _ Split text into multiple columns _ Sorting and Filtering Data
Excel Split one data column into multiples
play
05:00

Excel Split one data column into multiples
Bill Grace - The Ever Expanding Column Of Honored Names
play
01:15

Bill Grace - The Ever Expanding Column Of Honored Names
Ms Excel 2003 Training- column width row (Part 12)
play
06:07

Ms Excel 2003 Training- column width row (Part 12)
Dorit Kemsley Fires Back After Erika Jayne Names ‘RHOBH’ Costar, PK Kemsley as Next Bravo Couple to Split
play
01:15

Dorit Kemsley Fires Back After Erika Jayne Names ‘RHOBH’ Costar, PK Kemsley as Next Bravo Couple to Split
The names of Allah: Al Faliq (The Splitter of Seeds, He Who Clefts the Darkness and Produces the Morning)
play
02:17

The names of Allah: Al Faliq (The Splitter of Seeds, He Who Clefts the Darkness and Produces the Morning)
Christina Anstead Buys a Yacht and Names It ‘Aftermath’ Following Split from Ant Anstead
play
01:08

Christina Anstead Buys a Yacht and Names It ‘Aftermath’ Following Split from Ant Anstead
THE DIFFERENCE How to Combine Names in Excel Using TEXTJOIN and CONCATENATE
play
04:44

THE DIFFERENCE How to Combine Names in Excel Using TEXTJOIN and CONCATENATE
---Excel Basics #6- Names Cell Ranges and Functions
play
10:32

---Excel Basics #6- Names Cell Ranges and Functions