Displaying contents of 2 cells in another
 

Is there a way of displaying the following please:

Cell 1 = 21.21.34.21
Cell 2 = fseh1324A01

I want to put in cell 3-
Cell1/cell2 = 21.21.34.21/fseh1324A01 as text, not divide by.

Is there a function that can do this. Thanks

Displaying contents of 2 cells in another
 

=A1&"/"&A2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Seb Warmoth" wrote in message
...
Is there a way of displaying the following please:

Cell 1 = 21.21.34.21
Cell 2 = fseh1324A01

I want to put in cell 3-
Cell1/cell2 = 21.21.34.21/fseh1324A01 as text, not divide by.

Is there a function that can do this. Thanks

Displaying contents of 2 cells in another
 

Thanks Guys. Excellent!!!!!

"Sandy Mann" wrote:

=A1&"/"&A2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Seb Warmoth" wrote in message
...
Is there a way of displaying the following please:

Cell 1 = 21.21.34.21
Cell 2 = fseh1324A01

I want to put in cell 3-
Cell1/cell2 = 21.21.34.21/fseh1324A01 as text, not divide by.

Is there a function that can do this. Thanks

Displaying contents of 2 cells in another
 

Seb Warmonth, format the cell as text first or put a ' in front of it

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Seb Warmoth" wrote in message
...
Is there a way of displaying the following please:

Cell 1 = 21.21.34.21
Cell 2 = fseh1324A01

I want to put in cell 3-
Cell1/cell2 = 21.21.34.21/fseh1324A01 as text, not divide by.

Is there a function that can do this. Thanks

Displaying contents of 2 cells in another
 

=A1 & "/" & A2 should do it.

- John



On Mar 13, 5:49 am, Seb Warmoth
wrote:
Is there a way of displaying the following please:

Cell 1 = 21.21.34.21
Cell 2 = fseh1324A01

I want to put in cell 3-
Cell1/cell2 = 21.21.34.21/fseh1324A01 as text, not divide by.

Is there a function that can do this. Thanks