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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I take 3 cells in column B and fit them into a spot where. 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy paste data from a column to a row 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
Creating form on sheet 1 and having info move to sheet 2 4

Back
Top