wrapping

  1. L

    wrapping text issue

    Hi I have some issue with wrapping text. In the sheet below. Cell B7 has 5 lines. When I resize column B (make it wider). I will still have 5 lines and each line will have more white spaces. Why is that? why some text form the second line join the first line to fill the white space? Also cell...
  2. S

    Auto fit text in a cell without changing cell size with text wrapping

    hi dears, this is my first query to the forum. I need to autofit variable data in excel sheet without formating but with text wrapping. I am able to either of it,i.ewith wrapping text cell height changes & with shrink to fit it is coming in single line.
  3. M

    How to Select Next Column

    Hey Guys, I'm trying to get code written that will select the next column but am having trouble finding it online, and or just wrapping my head around how to do it, Please Help Thanks
  4. K

    Concatenate help from one worksheet to another

    I can't find a way, without creating a very long process, to concatenate text from a column A (counties) on Sheet1, based on conditions (date range in column B), to a single cell (A1) on Sheet2. The final value must not have duplicates either and text will need to be separated by commas...
  5. B

    Outputting a formatted text file (space delimited *.prn)

    Hi, Using EXCEL 2007, when I try to export a file as a formatted text file (space delimited), it always wants to wrap the resulting file (i.e., it will write out about half the length of each record, and then continue with the remaining half of the record at the end of the file). In other...

This Week's Hot Topics

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
Top