This answer assumes:
- you have a header row and, because of that, the first row containing your data is Row 2.
- that Column D is empty
Please see my notes at the end if the above assumptions are incorrect.
Following these steps will solve your problem:
- In cell D2 enter the following formula:
- Press enter
- Cell D2 should now produce the result you’re after (i.e. if cell B2 contained the name John and cell C2 contained the name Doe, cell D2 should now show Doe, John)
- Now copy the formula from cell D2 down all the rows in Column D
- The other cells in Column D should populate with the data you want
- Now select and copy all cells containing data in Column D
- Select cell E2 and press shift command V (or go to Edit > Paste Formula Results)
- Now select and copy all cells containing data in Column E
- Open your TextEdit document
- Go to Edit > Paste and Match Style
Now you should have all the data you wanted as text and in the format you need.
NOTE 1: - If your next blank column isn’t Column D, then at step 1 enter the formula in the next blank column (i.e. if your next blank column is Column F, then enter the formula in cell F2. This also means you’d adjust the other steps accordingly.
NOTE 2: - If you don’t have a header row, then at Step 1 you would enter the following formula instead:
=(C1&", "&B1) into cell D1. This also means you’d adjust the other steps accordingly.