2022-2024 Form

Instructions and help about First Name & Middle Initial if Joint Or Combined Return, Enter Both

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 I'll 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 we've broken down by first name middle initial and last name so I'll be using formulas that I build with functions and I'll be using just for different functions to break down this name into the component parts and that'll 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 I'm going to use the left function so be left and then open parentheses and you can see there's two argument