Splitting text of one cell in multiple columns

CA Rishabh Pugalia (ExcelNext) , Last updated: 07 January 2017  
  Share

Lets say you have a long list of full namesas shown below (Example: AbduSalaam, Ismael). You need to split the text as last name and first name in two different columns. Solution: You can apply Text to Column technique. It cuts the data into different columns. You need to specify the column de

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 2999/-

Offer Price : INR 1999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)

CCI Pro

Published by

CA Rishabh Pugalia (ExcelNext)
(Trainer)
Category Students   Report

Other Articles  
Comment   Share
11 Likes   19819 Views
Comments

Related Articles


Loading


Popular Articles




CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Trending Online Classes

view all classess

Follow us
OR add as source on Google news

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category