how to use textjoin with tab delimiter

I would like to copy composed text to a plain text box in another app and have it appear in columns. The obvious solution is to insert tabs. Unfortunately Jointext() will not accept a delimiter of CHR(9). The error is "The formula contains a number outside the valid range". CHAR() requires a number > 31.


Anyone know another way to insert a tab character into a string?


Thanks,

Don

MacBook Air 13″, macOS 14.6

Posted on Sep 20, 2024 11:28 AM

Reply
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how to use textjoin with tab delimiter

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.