I have a worksheet that I have to adjust the information to get the results I
need. I them want toi create another workbook putting the results in certin
columns.

first workbook
columa a
last name first name first name
Column b
foumula to move just last name
Column c
Formula to move first name first name

New Work book

column d last name
column e first name first name