There are times when someone has an odd request.  For example, taking all the values in all the cells and merging them into one cell.  Why?  I do not know but I do know that Excel is used for numbers not for large amount of text.  This request is easy when using any version of Excel and in Word 2010.  This following process eliminates the CONCATENATE formula. =CONCATENATE(A1,A2,A3,….)

Steps:

  1. Highlight all the cells in Excel
  2. Copy
  3. Go in Word 2010
  4. Right Click and under Paste Option
  5. Choose Keep Text Only Icon

Now all of the cells become one paragraph.  If you need to, copy it into one cell.

Advertisements