You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

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.