To get the first N characters of a string in JavaScript, call the slice() method on the string, passing 0 as the first argument and N as the second. For example, str. slice(0, 2) returns a new string containing the first 2 characters of str .

3:59 5:04 Get the Initials from a list of names in Excel - YouTube YouTube Start of suggested clip End of suggested clip And then we're gonna go and select our cell. And then we're gonna go find. And then we're gonna goMoreAnd then we're gonna go and select our cell. And then we're gonna go find. And then we're gonna go we're gonna look for our blanket game space quotation marks and then we're going to select the cell

JS var name = 'John Doe' var getInitials = function (name) { var parts = name. split(' ') var initials = '' for (var i = 0; i < parts. length; i++) { if (parts[i]. length > 0 && parts[i] !== '') { initials += parts[i][0]

You can then use the function like so; var fullname = 'badmos tobi'; initials(fullname); //returns BT var surname = 'badmos'; initials(surname); //returns BA var more = 'badmos gbenga mike wale'; initials(more); //returns BW; I hope this helps. To get the first name and last name initials, try using the function below.

Select the column of full names that you'd like to separate. Head to the Data tab > Data Tools group and click Text to Columns. On the first step of the Convert Text to Columns Wizard, select the Delimited option and click Next. On the next step, select one or more delimiters and click Next.

JS var name = 'John Doe' var getInitials = function (name) { var parts = name. split(' ') var initials = '' for (var i = 0; i < parts. length; i++) { if (parts[i]. length > 0 && parts[i] !== '') { initials += parts[i][0]