Excel Forum
Similar Content
Convert Numeric Dollar Values into Text in Excel - UDF
Macro: Convert a numeric dollar amount into its text equivalent. This UDF (user defined function)...
How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros
Tutorial: I'll show you how to create a message box popup window in Excel that contains text on mult...
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...

Highline Excel Class 13: Text functions & AMPERSAND

See how to transform data into useful data using formulas and Text functions such as; TRIM, PROPER, SUBSTITUTE, REPLACE, FIND, and LEFT. See how to use the ampersand and the CONCATENATE function to join data. See how to speed up slow calculating spreadsheets with a concatenated column that joins three criteria and makes conditional (criteria) summing (adding) quicker.

See how to: 1) create upper case for the first letter of each word, 2) extract only the last name, 3) extract only the first name, 4) get rid of extra spaces, 5) sum with 3 criteria using the ampersand and the CONCATENATION function.

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.