Manual automation - Need to add "ENTER" to a string in Excel which I can paste to another app

banik2008

New Member
Joined
Oct 25, 2012
Messages
5
Hello all,

I have the great misfortune of having to use a command-line DOS-type application (Putty) for some of my work. Instead of typing the commands manually each time, I have created an Excel file which looks up the different filenames and strings for me, which I can copy from Excel and paste as a command in Putty. This works fine for simple commands, but there are some which need the following sequence:

command FILENAME -modifier [ENTER]
n [ENTER]
y [ENTER]


I have tried using concatenations with CHAR(10) in the formula to simulate the [ENTER] key, but that doesn't work, as Excel adds quotation marks to the string, which makes it unusable.

Is there a way to simulate the sequence above so that I can just paste the output from Excel directly into Putty?

Thanks in advance for any ideas.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,629
Messages
5,838,453
Members
430,549
Latest member
jayjay2022

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