Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)

Download workbook: people.highline...
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
Topics in this video:
1. 23 Examples of Custom Number Formatting (00:18 min)
2. Custom Number Formatting For Unit Price for Invoice (15:33 min)
3. Three TEXT function examples for creating labels (16:26 min)
4. Extract First Name formula using LEFT and SEARCH (18:55 min)
5. LEN function (20:13 min)
6. Extract Last Name formula using REPLACE and SEARCH functions (21:38 min)
7. Extract Last Name formula using SUBSTITUTE function (23:15 min)
8. Create e-mail address from employee names using LOWER, LEFT, SEARCH, REPLACE functions (42:10 min)
9. Flash Fill to create e-mail address from employee names (26:00 min)
10. TEXT function to create time from Text Time Items and the backslash character to insert a character into a Custom Number formatting (Barry Houdini Trick) (27:52 min)
11. Flash Fill to create time from Text Time Items (29:43 min)

[@excelisfun]

Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)

[@SndfOmar]

Thank you very much Mike. The basics you taught 6 years ago, are still applicable today.

[@excelisfun]

Yes they are!

[@excelisfun]

William San, your Google settings disallow commenting on your comments. Here is a formula that may do what you want: =TEXT(A2,"0000-00-00 00\:00\:00")+0 Where A2 has the value: 20140212115156

[@Rohitkumar-wk2vo]

Can't believe this video uploaded 8 year ago.

[@excelisfun]

Still great today. I have posted more than 20 different classes here at KZbin, but the videos in this 2013 class are by far the most detailed and complete ever. The one on PivotTables is the most detailed video that I ever made.

[@zm2813]

Thanks a lot for sharing this!

[@MrSarky1992]

Hey, Another possible solution for getting Last name only: =RIGHT(A36,LEN(A36)-SEARCH(" ",A36)) That's nice as well.

[@sandeepkothari5000]

Mind blowing!

[@excelisfun]

Glad you like it, Sandeep!!!! Thank you for your support : )

[@iziaurrahman]

too good mate!

[@nak460]

hi Sir, that's great , but if i want to convert 5,000.00 by just type 5 so how can i do

[@williamsan2213]

how can I put value 20140212115156 to convert into display YYYY-MM-DD HH:MM:SS?

[@vvolfbelorven7084]

Is Flash a sort of formula or something?

[@alexsandor4673]

Hello Michael. I just found your channel, and I want to download the workbooks, but the link is unavailable. Can you help me to get those?

[@excelisfun]

I just checked, the links are working.

[@alexsandor4673]

@@excelisfun I tried to open the link from my phone & my laptop, but it says that the page took too long to respond, and when I do an internet scan, it says the page isn't working...

[@excelisfun]

@@alexsandor4673 Must be on your end. The web site is working on this end.

[@alexsandor4673]

@@excelisfun I also tried to download a file that is 4 years ago, but it's the same problem. maybe it's my region? but I don't think so...I'm from Europe if it can be a problem.

[@alexsandor4673]

@@excelisfun maybe you have a solution or something? it will be awesome if you maybe can help me with an solution...

[@anil11996]

great wow...........

[@excelisfun]

Glad you like it!

[@genofgod]

ExcelIsFun I have a question. Why whenever I try to custom format a credit card number to XXXX #### XXXX #### the last numebr always changes to a zero. How can I write the format to stop that from happening? Please assist