Insert test/valle from sheet1 to sheet2 with a text statement.

**bpope** · 03-18-2012, 11:45 PM

Hi all

Im trying to figure out if it is possible to insert text from a cell from another sheet to a another cell with text already in the new cell.

Example

IPoverEthernet ethernetIpAddress= "xxx.xxx.xxx" ethernetSubnetMask="255.255.255.248"

Where xxx.xxx.xxx is, comes from another sheet within the workbook. At one time, many moons ago, I thought I could do this, but have forgotten since then.

Any assistance would be great.

Thanks

**Pete_UK** · 03-19-2012, 05:22 AM

You can do it like this:

="IPoverEthernet ethernetIpAddress= "&CHAR(34)&Sheet2!A1&CHAR(34)&" ethernetSubnetMask= "&CHAR(34)&"255.255.255.248"&CHAR(34)

assuming the address is in A1 of Sheet2 as a text value in the format required.

Hope this helps.

Pete

Insert test/valle from sheet1 to sheet2 with a text statement.

LinkBack

Thread Tools

Rate This Thread

Display

Insert test/valle from sheet1 to sheet2 with a text statement.

Re: Insert test/valle from sheet1 to sheet2 with a text statement.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions