Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 23 October 2017
  1 Replies
  3.7K Visits
hi, i currently have some data in excel that i need to sort out.

the data is in 3 columns, with almost 3000 rows of such data. i need to merge the content of 3 columns per row, into 3 rows, in a single cell. I know i can apply concatenate, with the CHAR(10) to represent linebreak. However, these are actually commands that i want to run. is it possible to extract out the info i need automatically? when i "copy" out the content of the cell, the line breaks disappear. anyone able to advise?

i have an example of what i want to achieve. The end goal is to be able to copy out the cells into a text file.

  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL