remove cr

  1. H

    Copy Range of Cells, Removing CR&LF and Pasting to Notepad

    Hello I have a sheet "Data". Would like to copy a range "G11:H95". The range should have removed all CR&LF and replace the CR&LF with ";". This data is needed for a powershell script. After removing the CR&LF I would like to paste it to notepad in one line. How can this be accomplished. Thank...
  2. F

    How to remove a CR and LF form txt file

    I have a file with 147693 lines. I need to remove 6 pairs of CR and LF at the end of the first 6 lines, then skip one (which is a legitimate CR, LF) then continue to the following 6 pairs. Any help ho to do that? I understand I will have to write a macro to do this, but have no idea hoe to...

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