ExcelBanter - Entering Information Into Another Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Entering Information Into Another Column (https://www.excelbanter.com/excel-discussion-misc-queries/192565-entering-information-into-another-column.html)

Té

Entering Information Into Another Column

I have first and last names in column A, how can I transfer the last names
into Column B? In 07 theres an icon you can just click on, but I'm not sure
about 03.

Billy Liddel

Entering Information Into Another Column

"Té" wrote:

I have first and last names in column A, how can I transfer the last names
into Column B? In 07 theres an icon you can just click on, but I'm not sure
about 03.

Probably Data, Text to Columns and follow the wizard.

Peter

Té

Entering Information Into Another Column

Thank you!!!

All times are GMT +1. The time now is 10:22 PM.