AI tools can generte tables, charts etc during conversation. Here is how you can copy table from Perplexity AI and paste it anywhere you want.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.