unwrap

  1. K

    VBA - Unwrap text column by searching for header name

    Hello, I have to add a piece of code to the end of my current code. What I want to do is select the sheet named [consolidated], and search for the following three column headers; "Type1", "Type2", and "Type3"; and to unwrap the text on those entire columns.
  2. S

    Is there a way to unwrap a textbox so the data appears on one line and not several different lines

    I am trying to bulk copy data off a excel sheet onto a sharepoint list. I do this by 100 rows at a time, but there are fields that have sevral lines in to cell, which crash my copy in paste into SharePoint. What I usually do is click on the cell and click backspace so the data comes on to one...
  3. J

    Macro needed: Unwrap data matrix -- 2 columns to 1 row

    Thanks for taking the time to read my post! I have a data set as follows: <colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody> Cluster Point Sp1 Cov Sp2 Cov Sp3 Cov 1 1 a 2 b 2 d 2 f 2 g 2...
  4. J

    I need a Macro to unwrap a data matrix.

    Hello everyone! Thanks for taking the time to read my post. My situation is as follows: I have 11 Sheets (Sheet1, Sheet2,etc..) each has 215 columns and 215 rows. # 1 2 3 4 5 .... 1 0 2 .4 0 3 .2 .4 0 4 .1 .1 .1 0 5 .4 .5 .6 .2 0 Each column and row represents a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top