I have also used vim macros to do all sorts of text formatting that would have otherwise taken ages!!
One time my girlfriend needed to format a bunch of text, I don’t remember why. It was like a csv but couldn’t be opened in excel because it was badly formatted or something?
Anyway her work computer had vim on it, and I totally saved the day. Pretty much the proudest moment of my life lol. It was like this xkcd, but for vim https://xkcd.com/208/
The other day (we're being encouraged to "use AI" at work), I had a bunch of 20250101, 20250201, ... fields in a g-sheet at work. I decide to ask google's AI to "help out", hey... can you convert these integers to ISO date strings?
"Sure can do, old buddy, old, pal, here you go, it's '2025-01-01', '2025-02-01', etc..."
OK, great, can you put those rows into the spreadsheet now? "Whoah whoa... I used python code to do that for you" => "Can you do it with a spreadsheet formula or something? Can you replace those rows? What's the formula to convert this into a string / iso date? ...etc..."
Finally I'm just like "fuck it!", grabbed it in vim, `Ctrl-V, G, I-, ll.` and pasted it all back in. Like 10 keystrokes instead of arguing with our new robot overlords. :-D
If I'm not going to have to do it a bunch, sometimes vim itself is faster than writing a script to do whatever random task I need done.