Prashanth Srivatsa
banner
prashanthsrivatsa.bsky.social
Prashanth Srivatsa
@prashanthsrivatsa.bsky.social
Writer.
The Spice Gate - July 2024 (HarperVoyager)
Catsfather.
Sheets. Differs slightly for excel, where instead of transpose and split you use trim and textsplit.
October 30, 2025 at 4:42 PM
You'll need to split them first. There's a simple formula that can do it if you don't mind the extra column spent doing it.

Unique(transpose(split(textjoin(char(10),true,range),char(10))))

Add the range of cells where it says range.
October 30, 2025 at 4:39 PM
Congratulations, Cherae!
October 30, 2025 at 11:40 AM
I usually find a well placed comma often placates my software. It's what I call Comma and Conquer.
October 29, 2025 at 6:08 AM
These are all excellent books!
October 29, 2025 at 6:07 AM
Happy birthday, John!
September 4, 2025 at 2:39 AM
Thank you!
May 25, 2025 at 3:10 AM
Reposted by Prashanth Srivatsa
oh wow, another book I loved! a portal fantasy that I feel is somehow not getting read enough is The Spice Gate by @prashanthsrivatsa.bsky.social
May 24, 2025 at 12:15 PM
Thank you, Sophie! And huge congratulations to you too!
May 4, 2025 at 7:20 AM
Congratulations, Indra!
May 3, 2025 at 1:50 AM