shg, I'll take a look at that thanks
- - - - -
Aard:
In the spreadsheet is a column on the right, with the header: C & P
"C & P" stands for "Copy and Paste" - This is what I use as output from the spreadsheet
If you do a Ctrl+C on those four concatenated items under C & P, and paste it into Notepad++ (I use this) or Notepad,
I think you'll see what I'm talking about (I show it, above, if you don't).
If you just paste the text below in the same spreadsheet, you don't see it - Excel does something.
I don't need to use the ampersand at all with Concatenate?
. . . you learn something new every day!
I see that I didn't in the Sort formula to the right.
Bookmarks