|
1. The first step is to open your Google Sheet and click in column A header
|
|
2. Right Click to highlight the column
|
|
3. Click Insert 1 right
|
|
4. Click B1 to add a header title
|
|
5. Click A1 to rename the column header
|
|
6. Type First Name in A1
|
|
7. Click to select Column A and then go to Data
|
|
8. Scroll down and click Split text to columns
|
|
9. Scroll down and choose how to detect to separate
|
|
10. Click Space
|
|
11. Click Separator:Space
|
|
12. Now we have the columns split, let's update our import to Employment Details
|
|
13. Click the formula
|
|
14. Change the Range from A2:A to A2:B to include data from column B too and Press Enter
|
|
15. Click cell A2 to update
|
|
16. Scroll down and that's it. You're done. You've split text to columns and updated your =importrange formula
|
16 steps should take 1 minute