When you need to apply a minor tweak to the document, it must not require much time to Separate initials form. This kind of basic activity does not have to demand extra training or running through handbooks to learn it. With the appropriate document editing resource, you will not take more time than is needed for such a quick edit. Use DocHub to simplify your editing process regardless if you are an experienced user or if it’s your first time using a web-based editor service. This instrument will take minutes to learn to Separate initials form. The only thing needed to get more productive with editing is actually a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to spend on document editing regardless of your previous experience with such instruments. Make an account now and enhance your efficiency immediately with DocHub!
hello this is dr. grande welcome to my video on separating first name middle initial and last name using Excel as always if you find this video to be helpful please like it and subscribe to my channel I certainly appreciate it I have here in this Excel worksheet a string Ill be using for this example and this name structure is first name middle initial and last name and we see this in datasets where we get the strings all together we get the names all together and not separated out into separate variables and sometimes we do need this information weve broken down by first name middle initial and last name so Ill be using formulas that I build with functions and Ill be using just for different functions to break down this name into the component parts and thatll be the left right le n and find functions so in this first name to get the name first from the string and cell b2 Im going to use the left function so be left and then open parentheses and you can see theres two argument