Issue with Concatinating 2 columns in Sharepoint (Lookup)

Sep 28, 2010 at 4:21 PM

I am trying to conacatenate City/State/Country into one column.
I have the FloorSpace list in Sharepoint which has the following fields. Address (text field), City (look up from City List), State (Look up from State list based on City), Country (Look up from Country list based on City, state) and I have one Location where I want to concatenate all these 4 fields.... I tried the concatenate fomula... but it did not work for the look up columns.

I am not sure if this is the right place to post this request. I apologize if this is the wrong section.

Any advice would be very helpful



Sep 28, 2010 at 9:06 PM


I'm not sure of the answer for this. You might want to try the Stump the Panel forum over at


Sep 28, 2010 at 9:17 PM

Sure... thanks Marc... I will try that.