Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how to split values from a cell

  Asked By: Kent    Date: Nov 01    Category: MS Office    Views: 1575
  

i have value in cell A1 (Ex :- india rajashant jaipur , india punjab jalandhar
) i want to split these values in A2,A3 A4
i want result if A1= india rajashant jaipur
A2 = India
A3 = rajasthan
A4 = jaipur

Ex 2 if B1 = india punjab jalandhar
results
B2 = india
B3 =Punjab
B4 = Jalandhar

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Rebekah Walker     Answered On: Nov 01

Use "Text to Columns" found under the Data menu.

 
Didn't find what you were looking for? Find more on how to split values from a cell Or get search suggestion and latest updates.




Tagged: