full blog post:

Problem: Your data has a column for full name, and you need to create columns for first and last name. If you’re using Excel 2013, the Flash Fill feature may not be adequate because you need an auditable and verifiable methodology (i.e. use formulas).

Solution: Write two formulas, one for first name and one for last name. For first name the formula will use FIND and LEFT. For last name the formula will need RIGHT, FIND, and LEN.

Nguồn: https://12m-15m.org/

Xem thêm bài viết khác: https://12m-15m.org/category/cong-nghe

Very detailed video, thanks so much

if 3-4 character in someones name than, you explained only name with 2 character

pretty freaking slick

Hi Thanks it's useful vedio

I need one more for information please help me

how can split the location

Ex:C1-C5

Ans:C1,C2,C3,C4,C5

is there any formula to do above activity

good

Excellent formula. Thank you.

Thank you for this tutorial which will really help me in my work The illustrations at the appropriate point at each stage made the formulas much clearer to understand; doing that makes such subjects more appealing. It is a method used by the good teachers I have met.

I appreciate that so much! It helped a lot with my email Campaign

how do you do it when there are 3 names ?

excellent formulas for database work where Text to columns doesn't work!!!

I could only find pieces of this formula using the Help Menu in Excel, so thank you so much for putting it together for me!!!

How do I colour rows with multiples of 12 (row 12,24, 36 etc) as I need to highlight annual payments, but there are thousands of rows.

under data tab in the ribbon in excel it is way easier to use the option text to columns and not go to all this trouble in this video , this guy from the video should know better

Thank you Chris! Really helpful :O)

Hey Chris … Fantastic way to explain a complex formula !!! Thanks a lot man 🙂