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: 2770

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
B2 = india
B3 =Punjab
B4 = Jalandhar



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.