Entering Multiple References in One Cell

  • Thread starter Thread starter marc
  • Start date Start date
M

marc

Scenario:
######I am working on two different Tabs in an Excel Worksheet
###### Let's call them Tab A and Tab B
###### I have two dates (3/1/2008 & 4/1/2008) in two seperate cells in Tab A
######I would to reference them and have both values show up in a single cell

Example: Tab A Cell 1 - 3/1/2008
Tab A Cell 2- 4/1/2008
Goal: Tab B Cell 1 - 3/1/2008 , 4/1/2008

Thanks
 
 Scenario:
######I am working on two different Tabs in an Excel Worksheet
###### Let's call them Tab A and Tab B
###### I have two dates (3/1/2008 & 4/1/2008) in two seperate cells in Tab A
######I would to reference them and have both values show up in a single cell

Example: Tab A Cell 1 - 3/1/2008  
              Tab A Cell 2- 4/1/2008
      Goal: Tab B Cell 1 - 3/1/2008 , 4/1/2008

Thanks
Click to expand...

I may be oversimplifying but here is one way, just enter this formula
in the desired location in Tab B... it simply concatenates the two
values with a comma in between, I changed it to text as excel
displayed the numeric value for the date not the date itself, but you
get the point... just tweak as desired.

=CONCATENATE(TEXT('Tab A'!A1,"mm/dd/yyyy"),", ",TEXT('Tab B'!A2,"mm/dd/
yyyy"))
 
solid

[email protected] said:
I may be oversimplifying but here is one way, just enter this formula
in the desired location in Tab B... it simply concatenates the two
values with a comma in between, I changed it to text as excel
displayed the numeric value for the date not the date itself, but you
get the point... just tweak as desired.

=CONCATENATE(TEXT('Tab A'!A1,"mm/dd/yyyy"),", ",TEXT('Tab B'!A2,"mm/dd/
yyyy"))
Click to expand...
 
Back
Top