Answers for "separate first and last name in excel"

2

separate first and last name in excel

1.Make new column to the right
2.select column with the names
3.go to Data(menu) > text to columns
4.use dlimited for type
5.In the Delimiters section, select the item that separates your data.
(make sure to check the data preview)
6.Click the first column in the Data preview section and 
select the Column data format type as text.
7.choose destination (you can go with default) and click finish.
//for more complicated names see the source website
Posted by: Guest on March-15-2022

Code answers related to "separate first and last name in excel"

Browse Popular Code Answers by Language