ExcelBanter - Combine two linked fields in one cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Combine two linked fields in one cell (https://www.excelbanter.com/excel-programming/345600-combine-two-linked-fields-one-cell.html)

Helen

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

Norman Jones

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

Helen

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

All times are GMT +1. The time now is 12:19 AM.