Possible Concantenate

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Excel 200 Issue

I have 2 spreadsheets in the same workbook

Spreadsheet A
cell F9 value is 50
cell G9 value is 75

Spreadsheet B
cell E8 I want the value to be 50 - 75
with a space before and after the dash

Would I use the concantenate function?
If so, how do I go about doing this?

Thank you
 
Hi Karen!

No need for CONCATENATE function:

='[My First Workbook.xls]Sheet1'!$F$9&" - "&'[My First
Workbook.xls]Sheet1'!$G$9

With CONCATENATE it would be:

=CONCATENATE('[My First Workbook.xls]Sheet1'!$F$9," - ",'[My First
Workbook.xls]Sheet1'!$G$9)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Karen!

Correction. I confused myself. Your sheets are in the same workbook!

='Sheet No 1'!$F$9&" - "&'Sheet No 1'!$G$9


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Norman Harker said:
Hi Karen!

No need for CONCATENATE function:

='[My First Workbook.xls]Sheet1'!$F$9&" - "&'[My First
Workbook.xls]Sheet1'!$G$9

With CONCATENATE it would be:

=CONCATENATE('[My First Workbook.xls]Sheet1'!$F$9," - ",'[My First
Workbook.xls]Sheet1'!$G$9)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Karen said:
Excel 200 Issue

I have 2 spreadsheets in the same workbook

Spreadsheet A
cell F9 value is 50
cell G9 value is 75

Spreadsheet B
cell E8 I want the value to be 50 - 75
with a space before and after the dash

Would I use the concantenate function?
If so, how do I go about doing this?

Thank you
Click to expand...
Click to expand...
 
Back
Top