A delimiter is a sequence of one or more characters used to specify the boundary between separate, independent regions in plain text or other data streams. An example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values.
Common delimiters:
- Tab
- Colon
- Semicolon
- Comma
- Space
- Pipe
- Hyphen
Delimiters in Excel
Excel uses delimiters in the Text to Columns function. The options are tab ( ), semicolon (;), comma (,), space ( ), or other which is an input field for a single custom character.
Intro paragraph from Wikipedia https://en.wikipedia.org/wiki/Delimiter