Hi, I'm trying to figure out what's the best way to add the following strings.
1. I've a list of incidents on a spreadsheet.
INC000010
INC000011
INC000012
INC000013
INC000014
INC000015
2. I want to add Incident ID*+' = " before each incident follow by a " Or.
I want it to look like this on a single cell.
'Incident ID*+' = "INC000010" Or 'Incident ID*+' = "INC000011" Or 'Incident ID*+' = "INC000012" Or 'Incident ID*+' = "INC000013" Or 'Incident ID*+' = "INC000014" Or 'Incident ID*+' = "INC000015"
Would the concatenate function be the best way to achieve this?
1. I've a list of incidents on a spreadsheet.
INC000010
INC000011
INC000012
INC000013
INC000014
INC000015
2. I want to add Incident ID*+' = " before each incident follow by a " Or.
I want it to look like this on a single cell.
'Incident ID*+' = "INC000010" Or 'Incident ID*+' = "INC000011" Or 'Incident ID*+' = "INC000012" Or 'Incident ID*+' = "INC000013" Or 'Incident ID*+' = "INC000014" Or 'Incident ID*+' = "INC000015"
Would the concatenate function be the best way to achieve this?