Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 11 February 2022
  1 Replies
  1.8K Visits
0
Votes
Undo
I need assistance splitting more than 300 cells, including the sample cell record below, into different columns and rows by

Column 1 = [ :
for example [Temporary Workforce (Consultants / Contractors / Interns):
and for example [Employees:
Column 2 = ]
for example Contact Information]
and for example User Account Information]
Column 3 = ,
for example ***** - Home,Home Address - Zip / Postal Code
and for example Home Address - State / Province
Column 3 = ,
for example User Login Name
and for example User Login Password

[Temporary Workforce (Consultants / Contractors / Interns): Contact Information] ***** - Home,Home Address - Zip / Postal Code,Home Address - State / Province,Home Address - Street,***** - Mobile,Personal Email Address,Home Address - City; [Temporary Workforce (Consultants / Contractors / Interns): Professional Experience & Affiliations] Trade Union Membership; [Temporary Workforce (Consultants / Contractors / Interns): Employment Information] Job Grade/Code,Employment History,Employment/Work Records,Job Title; [Temporary Workforce (Consultants / Contractors / Interns): Personal Identification] Name - Last,Gender,Name - Middle,Age,Name - First,Date of Birth (mm/dd/yyyy); [Temporary Workforce (Consultants / Contractors / Interns): Health Insurance Information] Health Records; [Temporary Workforce (Consultants / Contractors / Interns): Government Identifiers] Driver's License Number,Social Security Number (full 9 digits); [Employees: User Account Information] User Login Name,User Login Password
7 months ago
·
#2463
0
Votes
Undo
Hi drjohncm,

To split cells, you can use the Split Cells feature of Kutools for Excel. However, you cannot split cells with different separators. Instead, you should have a common separator.

The tutorial for this feature: https://www.extendoffice.com/product/kutools-for-excel/excel-split-cell-by-delimiter.html

Amanda
  • Page :
  • 1
There are no replies made for this post yet.