| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine two linked fields in one cell
Hello,
I'm wondering if there is a way to combine two linked field in one cell, just one after the other... maybe separated with a "/"... ? I tried: =('Enter Shipper Data'!$B$6/'Enter Shipper Data'!$B$7) but that didn't work :-) Any suggestions? Thanks!! Helen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine two linked fields in one cell
Hi Helen,
Try: ='Shipper Data'!B6&"/"&'Shipper Data'!B7 --- Regards, Norman "Helen" wrote in message ... Hello, I'm wondering if there is a way to combine two linked field in one cell, just one after the other... maybe separated with a "/"... ? I tried: =('Enter Shipper Data'!$B$6/'Enter Shipper Data'!$B$7) but that didn't work :-) Any suggestions? Thanks!! Helen |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine two linked fields in one cell
Great!
Thanks! Helen "Norman Jones" wrote in message ... Hi Helen, Try: ='Shipper Data'!B6&"/"&'Shipper Data'!B7 --- Regards, Norman "Helen" wrote in message ... Hello, I'm wondering if there is a way to combine two linked field in one cell, just one after the other... maybe separated with a "/"... ? I tried: =('Enter Shipper Data'!$B$6/'Enter Shipper Data'!$B$7) but that didn't work :-) Any suggestions? Thanks!! Helen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine data based on two fields.. | Excel Discussion (Misc queries) | |||
| combine rows with similar data, but different fields in excel | Excel Discussion (Misc queries) | |||
| How to combine data files with different fields? | New Users to Excel | |||
| combine worksheets and populate fields | Excel Discussion (Misc queries) | |||
| How to combine dat from 4 fields into one field | Excel Worksheet Functions | |||
Linear Mode
