Choose a Consistent Separator: Select a single character or short sequence of characters that does not appear anywhere else within your data. A comma (,) is common, but a pipe (|), semicolon (;), or even ### can work well. For our example, | is a good choice.
Find and Replace (Standardize Delimiters):
Use the "Find and Replace" function (Ctrl+H or Cmd+H).
Goal: Replace whatever currently separates your "fields" (e.g., ; or , or just spaces) with your chosen brother cell phone list single consistent separator (e.g., |).
Find: ; Product: Replace with: |
Find: ; Date: Replace with: |
Find: ; Status: Replace with: |
Find: ; Order ID: Replace with: |
Find: Customer: Replace with: (leave blank, or replace with | if you want a blank first column, then manually delete it later).
Result after this step (for one line):John Doe|Widget A (Large)|2024-05-15|Shipped|1234.