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

Category:

Science & Technology

Tags:

• Excel
• extract
• last
• first
• name
• get
• rid
• of
• spaces
• TRIM
• PROPER
• REPLACE
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[imran01924400917]

from wherei can get the excel sheets for parctice?

[ExcelIsFun]

@imran01924400917 here:

people.highline.edu/mgirvin/Ex­celIsFun.htm

[TastyAnchovy]

You are a legend. An awesome one. Nothing on Itunes or elsewhere on the web compares to what you have done and made available. Thank you Mike

[ExcelIsFun]

You are welcome!

[alwayzsic]

would concatenate make it faster? without formulas?

[ExcelIsFun]

I am not sure I understand your question. Can you re-state?

[Hunyie1911]

A question in the REPLACE function here (used to extract First Name Only)...

=REPLACE(E14,1,FIND(", ",E14)+1,"") When I omit the space after the comma, the formula returns the same result, so that space is really unnecessary. Otherwise, you can always use =REPLACE(E14,1,FIND(" ",E14),"") if you know the first name starts right after the space, which is very commonplace. That formula is also a bit more simple and easier to understand.

Still, your Excel classes are wonderful. Thank you so much!!!!

[ExcelIsFun]

I am glad that they helped!

[ExcelIsFun]

You are welcome!

[alternativeblue123]

Thank you very much for your videos. They´ve been very helpful.