Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two columns that a client has sent me... unfortunately some contents are on another column. I want to make it so that all the data lines up in just column... how do I make this happen? alt text

share|improve this question

On a COPY of your workbook, I'd set up a formula in column G that concatenates the values in columns E and F, trims any excess "white" space or blank space (just in case), then copy and 'paste special /values' the results in G back into E.

Your formula in cell G1 might be =TRIM(CONCATENATE(E1,F1))

Or, use the ampersand (&) operator to concatenate: = TRIM(E1 & F1).

I personally prefer the "&" operator.

share|improve this answer
Exactly how I'd do it too. No Excel here, but I seem to remember there's also a Paste Special option that can add up, multiply, etcetera while pasting. Maybe there's also an option to concatenate on paste? – Arjan Dec 7 '10 at 13:43

Here is another choice, though it won't work if there is any other data to the right of this section of your spreadsheet.

  1. Highlight the whole area under question in this case E1:E3
  2. Press Ctrl + G
  3. Click Special
  4. Select Blanks; Click OK.
  5. Right-click on a selected cell and click Delete... and Shift Cells Left.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.