Copy a cell into notepad adds quotes

[fella5]

I have been trying to use excel to generate commands so that I can paste then into a Cisco switch. I want to enter a command and the have a carriage return and then enter "Y" and then another carriage return. The command needs to be entered (carriage return) and then the WLC ask to reboot the device (y/n) and I want to enter y then carriage return. I've tried using the CHAR(13),CHAR(10) and trying to use a replace or substitute. And I can't figure it out.

My cell formula i'm using is:
=CONCATENATE("config ap static-IP disable ",A1&CHAR(10)&"y"&CHAR(10)&CHAR(10))

What I want is to generate the following:
config ap static-IP disable AP-NAME
y

But when I past this into notepad, I get:
"config ap static-IP disable AP-NAME
y

"

Thanks!

 

[bensonsearch]

try setting a string variable to = "config ap static-IP disable "
then call the variable in the formula?

if this is something that can be done via DOS commands I would do that instead of notepads etc

 

[fella5]

try setting a string variable to = "config ap static-IP disable "
then call the variable in the formula?

if this is something that can be done via DOS commands I would do that instead of notepads etc

This is what I did and still has the " "

A1: = "config ap static-IP disable "
B1: ="y"
B1: =A1
B2: =A2
C1: =CONCATENATE(B1,CHAR(10),B2)

Output on notepad is: "config ap static-IP disable
y"

 

[bensonsearch]

I take it you have tried removing the "" from the word?

 

[fella5]

I take it you have tried removing the "" from the word?

Yes..... but I have users that don't want to cut and paste into word or notepad to remove the quotes. So I was just wondering if there way a way.

Thanks!

 

[poolhall]

As far as I know, the opening and closing quotation marks will always be added while copying cells with line breaks in them.

 

[ZVI]

A1: config ap static-IP disable
A2: y
Select A1:A2, copy the selection, paste it into notepad

 

[fella5]

A1: config ap static-IP disable
A2: y
Select A1:A2, copy the selection, paste it into notepad

Yeah... I've don't that. My problem is I have a sheet with columns of commands and the first cell in each row is the device name. So adding another row below the command will not work. It's okay I guess... They just have to paste into notepad and delete the ".

Thanks