Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

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.