Splitting Names into different cells in Excel
You can split the cells by following these steps:
-Select column A
-From the top menu, select Data and then Text to Columns
-Select Delimited and click Next
-Under the Delimiters heading, make sure only Space is selected and click Next
-Under the Destination area, type $B$1 and then click Finish
You can split the cells by following these steps:
-Select column A
-From the top menu, select Data and then Text to Columns
-Select Delimited and click Next
-Under the Delimiters heading, make sure only Space is selected and click Next
-Under the Destination area, type $B$1 and then click Finish
Posts
No comments