Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Talking of "the number" and "the name" concerning compound addresses is an excessive euphemism.
@robleyd already listed a few considerate examples reminding of this fact.

Never ever allow compound addresses entrance to a spreadsheet or a database!

Post factum, you have a full-grown case for AI. Just consider the multitude of "traditional" formats...

However, taking the subject literally, the version 6.2 of LibreOffice, aöready available as 6.2.0.3RC (most likely identical with the release) is offering a new means to do it: the REGEX() function using the extra parameters. See this attached demo Sheet. The AI part is not included.

Talking of "the number" and "the name" concerning compound addresses is an excessive euphemism.
@robleyd already listed a few considerate examples reminding of this fact.

Never ever allow compound addresses entrance to a spreadsheet or a database!

Post factum, you have a full-grown case for AI. Just consider the multitude of "traditional" formats...

However, taking the subject literally, the version 6.2 of LibreOffice, aöready already available as 6.2.0.3RC (most likely identical with the release) release to come soon) is offering a new means to do it: the REGEX() function using the extra parameters. See this attached demo Sheet. The AI part is not included. included.