Copying part of previous column (e.g first names) to current

Hi Sam

Thanks for your question. Yes there are a couple of ways to do this -

Using Text to Columns

1. Select the data containing your Fullnames and select Data, Text to Columns
2. Click on Delimited
3. Tick Space (rather than Tab)
4. Click Next and choose a destination cell for your first names.
5. Click Finish


Using Flash Fill

As you are using Excel 2013 a fun and easy way to do this is:

1. Type the first name for the first person to the right of your fullnames.
2. Highlight the cells to be filled including the name just typed in and choose Data, Flash Fill.

Hope that work!

Regards
Doug
STL