WaelYassin
Technical User
Dear All,
I am trying to use excel sheet to do the following, i have a set of strings that can be output from other program, i want to paste them in Excel then go through each cell contents and concatenate it with (.|) then the next cell contents.
Example:
Brown
Yellow
Red
Black
Output should be: Brown.|Yellow.|Red.|Black
I am trying to use excel sheet to do the following, i have a set of strings that can be output from other program, i want to paste them in Excel then go through each cell contents and concatenate it with (.|) then the next cell contents.
Example:
Brown
Yellow
Red
Black
Output should be: Brown.|Yellow.|Red.|Black