Excel Tip – Text Functions #1

There are times text needs to be converted to lower case, proper case, or upper case for consistency sake. Excel provides functions to easily convert text in these cases.

However, Excel does not convert text to sentence case — the first letter only is capitalized. Using a combination of functions will easily convert text to sentence case.

The formula to convert the text in A1 is:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

For examples, see the following:

Examples of text functions.
Examples of Text functions

Next week will continue with more useful text functions.

FaceApp – Invasion of Privacy?



A recent trend in social media is the use of FaceApp. Upload your photo and it will return an image of how you would look in the future. You may also use the app to change your appearance in a variety of manners. Although it appears to be a fun use of Artificial intelligence, are you also giving them permission to use your photo?

Images using FaceApp aging filter
Images using Faceapp aging filter

From FaceApp’s Terms and Conditions: ” You grant FaceApp consent to use the User Content, regardless of whether it includes an individual’s name, likeness, voice or persona, sufficient to indicate the individual’s identity. By using the Services, you agree that the User Content may be used for commercial purposes.  “

According to this, they can use your photo as they like — including selling it.

To read more about their policy:

https://www.businessinsider.com/faceapp-privacy-data-terms-service-russia-2019-7



New Forensic Accounting Standards

The AICPA issued new standards for those that perform forensic accounting services engagements.

The standard defines forensic services as those “provided for investigation or litigation”.

To read more about the release of standards, go to: https://www.journalofaccountancy.com/news/2019/jul/forensic-accounting-aicpa-standards-201921580.html

To review the Statement on Standards for Forensic Services No. 1, go to: https://www.aicpa.org/content/dam/aicpa/interestareas/forensicandvaluation/resources/standards/downloadabledocuments/ssfs-no-1.pdf

The Downside of electric cars

Can their be a downside? When electric cars are running, they are virtually silent. This poses a danger to those that may be visually impaired, shorter, or even those that are distracted.

Electric car
Electric Car

The European Union has proposed that these cars be fitted with an Acoustic Vehicle Alert System that will vary the noise with the speed of the vehicle.

To read more about this feature, go to: https://sfmagazine.com/technotes/june-2019-quiet-streets-are-becoming-too-dangerous/