To split names and surnames in Excel, use the built-in Text to Columns feature (Data tab > Text to Columns > Delimited > Space) for a quick separation, or leverage the newer TEXTSPLIT function (e.g., =TEXTSPLIT(A1," ")) for dynamic splits, or try Flash Fill (Ctrl+E) by providing a few examples to show Excel the pattern.
In Microsoft Excel, Ctrl+F12 is a shortcut that opens the "Open" dialog box, allowing you to browse for and open an existing workbook file, similar to going to File > Open. It's a handy way to quickly access your saved files without using the mouse, though on some laptops you might need to press Ctrl + Fn + F12.
Ctrl+F3 Open Excel name manager. Ctrl+F4 Closes the selected workbook window. Ctrl+F5 Restores the window size of the selected workbook window. Ctrl+F6 Switches to the next workbook window when more than one workbook window is open.
The SPLIT syntax in Excel is used to separate a text string into multiple parts based on a specified delimiter. The syntax for the SPLIT function is: =SPLIT(text, delimiter, [limit]) - "text" is the text string that you want to split. - "delimiter" is the character or string that determines where to split the text.
Separate first and last names in Excel
Ctrl B is a keyboard shortcut used in various applications and operating systems to perform certain actions. It is typically used to apply bold formatting to selected text.
In this video, I will teach the role of Ctrl + K in Microsoft Excel When you press Ctrl + K, a hyperlink box will appear. Basically, hyperlink is a link that connects you to any cell, sheets in Microsoft Excel or even other files and Internet.
F1 – Opens the Help screen for almost every program. F2 – Allows you to rename a selected file or folder. F3 – Opens a search feature for an application that is active at the moment. F4 – Alt + F4 closes the active window. F5 – Allows you to refresh or reload the page or document window.
Using Ctrl + T to create a Table in Excel.
The Ctrl + F4 keyboard shortcut is primarily used to close the active tab or window within an application, making it great for quickly closing one document or webpage without exiting the whole program, unlike Alt + F4, which closes the entire application. In web browsers, it closes the current tab; in programs like Microsoft Excel, it closes the active workbook, leaving Excel open.
Assuming the full name is in column A:
In cell B1, you can use the formula =LEFT(A1,FIND(" ",A1)-1) to extract the first name. In cell C1, you can use the formula =MID(A1,FIND(" ",A1)+1,LEN(A1)) to extract the last name.
Split a column by delimiter
For example, a Name column that contains values written as <LastName>, <FirstName> can be split into two columns using the comma (,) character. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit.
To combine first and last names, use the CONCATENATE function or the ampersand (&) operator. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.
Click on the top of the column with your contacts' names to highlight the whole column. Click on the Data tab and select the "Split text to columns" option. From the Separator menu, select the "Space" option. Update the column headers so that each column is clearly named "First Name" or "Last Name."
Alt+E+S+H+Enter: Pastes the cell formatting and contents of the source cell. Alt+E+S+X+Enter: Pastes the contents of the source cell without borders. Alt+E+S+W+Enter: Pastes the width of the column with the source cell. Alt+E+S+R+Enter: Pastes the number formats and formulas from the source cell.
Press Ctrl+F, and then type your search words. If an action that you use often does not have a shortcut key, you can record a macro to create one. For instructions, go to Automate tasks with the Macro Recorder. Download our 50 time-saving Excel shortcuts quick tips guide.
Ctrl+R is a keyboard shortcut that is commonly used in web browsers to reload the current webpage.
If Ctrl B doesn't work in a particular application, it could be due to different key combinations being used or the application not supporting this specific shortcut. Check the application's documentation or help resources to find the appropriate method for applying bold formatting.
Key PointsCtrl+P is a shortcut key often used to print a document or page. It opens a print preview of the current page or document.
Try it!
The Ctrl+` or Ctrl+~ keyboard shortcut is most commonly used in Microsoft Excel to changes between displaying cell values or formulas. Below are other programs that use this keyboard shortcut and related information.