Split Function

One of the powerful functins of Excel VBA is Split function. Split function splits (parse) the string data with a given separator. For example, “Turkey/İzmir/Urla” string data can be splitted as follows:

Turkey

İzmir

Urla

Code required:

Dim StringParts() As String

StringParts  = Split( “Türkiye/İzmir/Urla” , "/" )

StringParts (0) = "Türkiye”

StringParts (1) = "İzmir"

StringParts (2) = "Urla"

What will be the date after 3 months form now?

What will be the date after 3 months form now?

=EDATE(date, number of months)

Excel's new ew artificial intelligence (AI) features explained by Microsoft.

New tools (Ideas), new data types and new fuctions added Excel to provide artificial intelligence (AI) features. 

These functions:  FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, SINGLE, and RANDARRAY.

More information:  https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/24/bringing-ai-to-excel-4-new-features-announced-today-at-ignite/

Excel in business life

https://www.facebook.com/EngineeringML/photos/pb.1701212786658447.-2207520000.1564390695./2251719211607799/?type=3&theater