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

[Heinrichxx]

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 you
Heinrichxx

 

[Heinrichxx]

Glad it is working for you. @OaklandJim's did a great job given how little information was provided in the initial request.
His code was nice and clear so it was pretty ease to incorporate the additional information you provided in post #3 into his code.

Hi OaklandJim
Hi Alex
You are right and the script is understandable.
Yes he did a great Job.
Sorry that it was not so understandable:
Have you both a great time and keep healthy
Heinrichxx

 

[Heinrichxx]

Great Job
Thank you all