In this article, you will learn:
How to extract the data in an excel file from one column into two columns
How to remove the spacing in column B
Tip💡: This is a useful trick to split the column of employee full names from the Employee Timecards report into two separate columns i.e. Column A Last Name, Column B First Name for certain payroll software such as Brightpay.
How to split the data in one column into two columns
Open up your Employee Timecards csv file exported from the Reports tab on Bizimply
Click column B at the top of the report
Right click column B
Select 'Insert' from the drop down menu and a new blank column will appear
Click column A at the top of the report
Click into the 'Data' tab that appears at the top right of screen
Select the 'Text to Columns' button
A pop up will appear - ensure the 'Delimited' option is selected as the format and click 'Next >'
In the next pop up, ensure that only the 'Tab' and 'Comma' options are selected and click 'Next >'
In the next pop up, ensure column data format is 'General' and click 'Finish'
Now that the data has been split into two columns, you will need to remove the space in front of the First Name in column B.
How to remove the spacing in column B
Highlight all the names listed in column B
Click 'ctrl' and 'f' on the keyboard or on Mac, you can click 'Edit' at the very top of screen, select 'Find' from the drop down menu and click 'Replace...'
A pop up window will appear - in the 'Find' field, click the spacebar on your keyboard once
Ensure the 'Match case' box is selected
Click the 'Replace' button at bottom left and then select the 'Replace All' button
The space at the start of each cell
Related Articles: