Google Sheets Text Functions With Find and Len
Using find and len in conjunction with left, right, and mid functions you can pull text out of strings of variable lengths. By finding patters in your text strings you can separate an entire string of text into separate columns.