excel151515
New Member
- Joined
- Apr 17, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Long time reader, first time poster. This is the first time I have not been able to find a solution to my problem.
My goal is to get excel to join a series of texts into a sentence that has commas between each text string, with "and" between the last and second last string. I can create the comma separated list using the textjoin function, but cannot figure out how to insert an "and" prior to the last string.
By way of example, I have 3-6 points of criteria, for example colours, that may apply to a specific product. For "Product A", where "blue" "red" and orange" apply, I want a cell which states "blue, red, and orange".
Any help is greatly appreciated!
My goal is to get excel to join a series of texts into a sentence that has commas between each text string, with "and" between the last and second last string. I can create the comma separated list using the textjoin function, but cannot figure out how to insert an "and" prior to the last string.
By way of example, I have 3-6 points of criteria, for example colours, that may apply to a specific product. For "Product A", where "blue" "red" and orange" apply, I want a cell which states "blue, red, and orange".
Any help is greatly appreciated!