I don't quite understand the question based on what you posted, but if you want to simply have the contents of columns B-E appear in column A, then use:
=CONCATENATE(B1," ",C1," ",D1," ",E1)
For your attachment, I get:
JON SELLENRICK AR1111955 MASON BENNETT AR1111955 SCOTT DESOTEL AR1111955 STEVE PIGG AR1111955
I added spaces to make it easier to read, but it doesn't really make much of a difference with that data.
Hope that helps.
rky.
Bookmarks