Can I do it where a1 is the value used in each cell. ie.,

Column A
Bock, Sally
apple
pears

to: Bock, Sally apple
Bock, Sally pears

"Dave Peterson" wrote:

=a1&a33
???



cs_vision wrote:

Can I concatenate two different rows in a column?

--

Dave Peterson