Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Excel's Text to Columns: Name List as Example

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Mon Jan 16, 2017 11:25 pm    Post subject: Excel's Text to Columns: Name List as Example Reply with quote

Microsoft Excel's Text to Columns is a powerful feature that can split texts into multiple columns. You find it under Data > Data Tools > Text to Columns . With the keyboard shortcut ALT + A + E you can also access this feature.




In the following example, I will separate the list into first name, middle name and last name. It's a three step procedure.


First, select your data set (A2:A9).





Under Data tab > from the Data Tools group click Text to Columns. This will open the Convert Text to Columns Wizard. Look, every wizard has a Data preview window to see how your data is taking new shape Smile


Step 1: select Delimited > click on Next. By default Delimited is always selected.





Step 2: select Comma and Space as your Delimeters. You will see an immediate change in the Data preview window below. Click Next.





Step 3: select cell B2 as your Destination > click Finish.





Your results are now displayed in cell B2.







*Short note: What are delimiters?

Delimiters are characters like commas ( , ), semicolon ( ; ), slashes ( / ) or special signs like @ that separate each field in your data. In this example Comma and Space are your delimiters.

So, have fun my friends Smile





*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group