how to split excel fields?

Question

Lakhimpur, NT Road , City - North Lakhimpur , District - Lakhimpur , Region - Assam Contact Person: MR. MONU DUTTA Phone:
this is my data now how to split the following Fields

Address, City, District, Region, Contact Person, Phone

please any one help me.........

Answer 1

If your data is separated by commas, this is quite easy. Make sure you have at least 6 empty columns after your address column. Select Text to Columns from the Data tab. In the pop up window, select Delimited and then Next. On the second step, select Comma and look at the preview pane at the bottom of the window. You should now see all of your data separated into nice, neat columns. You can click Finish now or you can click Next to format the individual columns (date, number, text or other special formats).



Before you do Text to Columns, you might want to replace your " , " (space comma space) with just a single comma or your new columns will each start and end with an unnecessary blank space. You can do this by using Find and Replace (Ctrl+H). In the first field, enter space comma space " , " and put a comma only in the second box and hit replace all. Your data delimiters (the commas and spaces between your fields) will now just be a single comma with no added spaces and your columns won't start and end with unnecessary spaces.



If you want to get rid of "City - ", "District - ", "Region - " and the other data tags in your addresses, do these the same way. Enter "City - " (without the quotes) into the first box of the Find and Replace pop up and leave the second box blank. Every instance of "City - " will be removed from the list. You can do this step either before or after doing the Text to Columns.



Insert a row at the top and type in your field headers and you should now have a nice, neat list that you can easily sort and merge.

Answer 2

Just write column heading as Address, City, District, Region, Contact Person, Phone

then enter your data after in bellow cells like



Lakhimpur, NT Road , City - North Lakhimpur , District - Lakhimpur , Region - Assam Contact Person: MR. MONU DUTTA

Answer 3

Download the Kutools for your excel and it will appear in the excel sheet when u open.

Then select your data and go to "select tools" then wht do u want select the option, all your requirement will be done easily.



ok, best of luck