Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search Products
Filter by Categories
B-BBEE
Blog
Company Secretarial
Featured
General Business
General Interest
Investing in Property
Marketing
Personal Growth
Personal Wealth
Tax
Trusts and Estate Planning
Uncategorized
0 items - R0

Excel new TEXTJOIN() and TEXTSPLIT() functions

Did you spot the new Excel functions?

I’m already using them extensively. This is not an instruction article. You should rather watch a UTube video.

I just want to be sure that you are aware of them, because I only found out from my daughter who is an Excel specialist.

So, Goodbye =A23&” “&B23&” “&C23

Hello =TEXTJOIN(” “,TRUE,A23:C23)

TEXTSPLIT saves a lot more difficult formulation by separating text into individual cells

TEXTSPLIT(I6,” “) separates the contents of I6 which is Derek Peter Springett into  J6 Derek K6 Peter L6 Springett. that one is a winner, because I could never remember how to write a formula to do it.

 

2 comments

  1. David G Hart

    Thanks! I must investigate the TEXTSPLIT function. Every couple of years I parse out a text directory file listing into a structured index of documents. This is a tedious process involving finding the locations of “\” and extracting the directory names from a file path.

    Reply

Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Looking for even more informative content? Check out the books I have written which have proved to be very popular.

Need help with your Trust or Business?

Contact us today or set up a free meeting with our CEO, Derek Springett. We have been offering expert advice and business services since 1971. You can also view see our full list of services.