how can I take 3 cells and move them to a different column into 1
 

need formula or process to move 3 consectuive cells from column B to one cell
in column A without manually insertng 2 new cells and copy and paste. Need
to do it for extensive data sheet and would take a long time to do it
manually. Is there a quicker way?

Almost certainly needs code, but a little more detail on the problem is
perhaps needed

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"manz77" wrote in message
...
need formula or process to move 3 consectuive cells from column B to one
cell
in column A without manually insertng 2 new cells and copy and paste.
Need
to do it for extensive data sheet and would take a long time to do it
manually. Is there a quicker way?