Thread: Displaying contents of 2 cells in another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl John Michl is offline
external usenet poster
  
Posts: 81
Default 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


Reply With QuoteReply With Quote