Jul 29 2021 02:02 AM
Hi Folks
fighting with a simple task.... want to get Column A and Column B in Column C
Example Input
US
ServerX
Example Output
US - ServerX
My Way
=CONCATENATE([Location];"-";[Title])
if I want to save it, Error - no valid syntax
Jul 29 2021 03:26 AM - edited Jul 29 2021 03:27 AM
@PaddyB you just need =[Location]&"-"&[Title]
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Jul 29 2021 04:29 AM
Hi @RobElliott
thanks so much... already a bit better... if i use
=[Location]&"-"&[Title]
i still get an error. if I use for example =[Likelihood]&"-"&[Title] it works... what is the difference?
the "Location" is a Dropdown the other are normal cells with numbers and / or text... can this be a Problem?
Jul 29 2021 04:50 AM