Displaying contents of 2 cells in another

G

Guest

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
 
S

Sandy Mann

=A1&"/"&A2

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
G

Guest

Thanks Guys. Excellent!!!!!

Sandy Mann said:
=A1&"/"&A2

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
P

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top