You are here:
- Home
- Computing/Technology
- Microsoft Software
- Excel
- Splitting text in 1 cell into 2 cells
Excel/Splitting text in 1 cell into 2 cells
Advertisement
Question
I am using Excel 2004 on a Mac os 10.4 computer.
I have a list of 1300 names and address, each having the persons name and address in the same cell. In order turn it into a mailing list I need to separate the name into a separate cell from the address. Is there a way to do this without copy and pasting all 1300 names?
Thanks
Answer
What I don't know is how the data is formatted - what seperates the name from the address? If for example it was the first instance of a comma, then it could be done with string functions (search, left, right) - if you can update me on this I can try and help further - if it is of any use, you can email me at aidan.heritage@virgin.net
Related Articles
- Color Quoted Text in Mac OS X Mail
- Copy and Paste Text Styles in Mac OS X Mail
- How to Add a Member to a Mailing List in Windows Mail or Outlook Express - About Email
- How to View Richly Formatted Mail in Plain Text with Mac OS X Mail - About Email
- How to Use Tables and Lists in Mac OS X Mail - About Email
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Answers by Expert:
- Nathan Head
- Chad Welch
- Philip Buckley
- Tushar Sakhalkar
- Bhaskar
- Amal
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bob Umlas
- Edward H. Mori
- Jessica L.
- Jan Karel Pieterse
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- Craig
- Adelaide carvalho
- Miguel Zapico
- JP
- Douglas M. Smith
- Richard Rost
- Ken Marron
- Victor Lan
- Bill
- Anne Troy
- Claire Blinman
Aidan Heritage
Expertise
I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards
Experience
My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.
Education/Credentials
I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!
©2009 About.com, a part of The New York Times Company. All rights reserved.