{"id":8649,"date":"2024-08-13T17:52:41","date_gmt":"2024-08-13T17:52:41","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=8649"},"modified":"2024-08-14T08:37:03","modified_gmt":"2024-08-14T08:37:03","slug":"combine-first-and-last-name-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel","title":{"rendered":"How to Combine First and Last Name in Excel?- (4 Ways)"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">In Microsoft Excel, combining first &amp; last names is a common task in data management, whether you are dealing with customer information, employee records, or any list that requires full names. However, this process is essential for ensuring that data is properly formatted and easy to read. Well, in this blog, I will discuss the workable solutions on <strong>how to combine first and last name in Excel<\/strong> and make the process more efficient &amp; error-free.<!--more--><\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To fix corrupt Excel file, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>How to Combine First and Last Name in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Combining the names in Excel can restructure your data processing tasks. It allows you to generate full names in the single column, making it easier to sort, search, and manage data.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Here, I have discussed a few effective methods for <strong>how to combine first name middle name and last name in Excel (using formula).<\/strong><\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<h3 style=\"text-align: left;\"><strong>Quick Navigation:<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Use CONCATENATE Function<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Using Flash Fill<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Use Ampersand Operator (&amp;) for Merging the Names<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Use Excel\u2019s TEXTJOIN Function<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 1- Use CONCATENATE Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">As we all know, the <strong>CONCATENATE function<\/strong> in MS Excel allows to combination of multiple strings or cell values into one. Likewise, you can use this function to merge text names within the spreadsheet.<\/p>\n<p style=\"text-align: justify;\">To do so, follow the below steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li>First of all, select the cell(s) where you need the combined name to seem.<\/li>\n<li>Then, enter the below formula:<\/li>\n<\/ul>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\">\u201c<strong>=CONCATENATE(first_name_cell, \u201c \u201c, last_name_cell)\u201d<\/strong><\/p>\n<\/div><\/div>\n<p style=\"text-align: justify;\">This will combine both the first &amp; last names from their corresponding cells.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Now, hit <strong>Enter<\/strong> key to act the formula &amp; display the joint name.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8655 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/How-to-Combine-First-and-Last-Name-in-Excel.png\" alt=\"How to Combine First and Last Name in Excel\" width=\"554\" height=\"204\" \/><\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Please Note<\/span>:<\/strong> CONCATENATE function cannot handle complex formatting or conditions.<\/p>\n<\/div><\/div>\n<a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 2- How to Combine First and Last Name in Excel Using Flash Fill?<\/strong><\/h3>\n<p style=\"text-align: justify;\">You can even use the <strong>Flash Fill<\/strong> feature to get this job done. This is a nifty functionality that attempts to give you the result after understanding the pattern.<\/p>\n<p style=\"text-align: justify;\">So, let\u2019s follow the below instructions carefully to combine the names of cells using Flash Fill.<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Under the cell <strong>C2<\/strong>, you have to type the result you need. We have taken \u2018<strong>Bobby Baker\u2019<\/strong> as an example.<\/li>\n<li style=\"text-align: left;\">In the cell <strong>C3<\/strong>, type the expected result.<\/li>\n<li style=\"text-align: left;\">At this time, you will see that MS Excel displays you the predictable result within all the cells. This is Flash Fill in action &gt;&gt; click <strong>Enter<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">Now, you will see all the cells filled with the combined name.<\/p>\n<p style=\"text-align: left;\">If in case, you won\u2019t see Flash fill while you\u2019re typing in the next cell, you should follow these steps to make Flash Fill work:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Firstly, under the cell <strong>C2<\/strong>, you have to type the result you need. We have taken \u2018<strong>Bobby Baker\u2019<\/strong> as an example.<\/li>\n<li style=\"text-align: left;\">Select <strong>C3<\/strong> &gt;&gt; go to the <strong>Home<\/strong> tab<\/li>\n<li style=\"text-align: left;\">Under an <strong>Editing<\/strong> group, you have to choose the <strong>Fill<\/strong> icon &gt;&gt; Click <strong>Flash Fill<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6955 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/flash-fill-in-excel8.png\" alt=\"How to Combine First and Last Name in Excel\" width=\"699\" height=\"425\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/flash-fill-in-excel8.png 699w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/flash-fill-in-excel8-300x182.png 300w\" sizes=\"auto, (max-width: 699px) 100vw, 699px\" \/><\/p>\n<p style=\"text-align: justify;\">That\u2019s it.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel\">Methods To Merge Rows and Columns in Excel Without Losing Data<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 3- Use Ampersand Operator (&amp;) for Merging the Names<\/strong><\/h3>\n<p style=\"text-align: justify;\">Many Excel users are unaware of the shortcut known as the Ampersand (&amp;) operator. This shortcut allows you to combine text of two cells more effectively and hassle-free.<\/p>\n<p style=\"text-align: justify;\">Here are the complete steps to do so:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Select the cell(s) where you need the combined name to display.<\/li>\n<li>After this, enter the below formula to merge the names and hit <strong>Enter<\/strong>:<\/li>\n<\/ul>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>\u201c=first_name_cell &amp; \u201c \u201c &amp; last_name_cell\u201d<\/strong><\/p>\n<\/div><\/div>\n<ul style=\"text-align: justify;\">\n<li>Now, you will get the names combined.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8656 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/3-2-1-700x373-1.png\" alt=\"Ampersand Operator\" width=\"700\" height=\"373\" \/><\/p>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 4- Use Excel\u2019s TEXTJOIN Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">Being an Excel user, you must be aware of various functions and formulas that help maintain the spreadsheet more precisely. One such function is <strong>TEXTJOIN<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Well, if you are working with the large dataset that contains multiple names, then this function can assist you to <strong>combine first name middle name and last name in Excel (using formula)<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Here\u2019s how you can use this TEXTJOIN Function:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Select the cell(s) where you need the combined name to display.<\/li>\n<li>Then, enter the below formula to combine the names from the stated ranges, divided by a space.:<\/li>\n<\/ul>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>\u201c=TEXTJOIN(\u201c \u201c, TRUE, first_name_range, last_name_range)\u201d<\/strong><\/p>\n<\/div><\/div>\n<ul style=\"text-align: justify;\">\n<li>Now, hit the <strong>Enter<\/strong> to apply this function &amp; display the combined name.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8657 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/TEXTJOIN-formula-to-combine-first-and-last-name.png\" alt=\"TEXTJOIN-formula-to-combine-first-and-last-name\" width=\"550\" height=\"421\" \/><\/p>\n<p style=\"text-align: justify;\">And you are done!<\/p>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n<p style=\"text-align: justify;\">        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Formula for Merge in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe formula for merge in Excel is =CONCATENATE (text1,text2,...).                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Where Is Combine in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can find combine or merge in Excel by navigating to the <strong>Home<\/strong> tab &gt; <strong>Alignment<\/strong> group, clicking the <strong>Merge &amp; Center<\/strong> option.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Add a Space Between Two Names in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo add a space between two names in Excel, you can use this function: <strong>=AddSpaces(pValue As String)<\/strong> As String.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Combine First and Last Name in Excel with Dot?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo combine first and last names in Microsoft Excel, use the <strong>CONCATENATE<\/strong> function or ampersand (&amp;) operator.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Formula for Merge in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The formula for merge in Excel is =CONCATENATE (text1,text2,...).\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Where Is Combine in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can find combine or merge in Excel by navigating to the <strong>Home<\/strong> tab &gt; <strong>Alignment<\/strong> group, clicking the <strong>Merge &amp; Center<\/strong> option.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Add a Space Between Two Names in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To add a space between two names in Excel, you can use this function: <strong>=AddSpaces(pValue As String)<\/strong> As String.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Combine First and Last Name in Excel with Dot?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To combine first and last names in Microsoft Excel, use the <strong>CONCATENATE<\/strong> function or ampersand (&amp;) operator.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: justify;\"><strong>Packing Up<\/strong><\/h2>\n<p style=\"text-align: justify;\">Last but not least, merging first and last names in MS Excel is a simple task that can be accomplished using numerous methods such as <strong>Flash Fill feature, CONCATENATE function<\/strong>, and other ways specified in this post. All you need to do is to pick the technique that best suits your needs.<\/p>\n<p style=\"text-align: justify;\">I hope you enjoyed reading this post!<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>External References:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/combine-first-and-last-names-6a2c1222-837d-482e-94f0-a38a4effb1b5\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/combine-first-and-last-names-6a2c1222-837d-482e-94f0-a38a4effb1b5<\/a><\/li>\n<\/ol>\n<\/div><\/div>\n<br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In Microsoft Excel, combining first &amp; last names is a common task in data management, whether you are dealing with &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Combine First and Last Name in Excel?- (4 Ways)\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#more-8649\" aria-label=\"Read more about How to Combine First and Last Name in Excel?- (4 Ways)\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":8650,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[1814,1815],"class_list":["post-8649","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-how-to-combine-first-and-last-name-in-excel","tag-how-to-combine-first-name-middle-name-and-last-name-in-excel-using-formula","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Combine First and Last Name in Excel?- (4 Ways)<\/title>\n<meta name=\"description\" content=\"Mastering the tactics specified in this blog will help you to combine first and last name in Excel, improve your data handling capabilities.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Combine First and Last Name in Excel?- (4 Ways)\" \/>\n<meta property=\"og:description\" content=\"Mastering the tactics specified in this blog will help you to combine first and last name in Excel, improve your data handling capabilities.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-13T17:52:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-14T08:37:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"309\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Combine First and Last Name in Excel?- (4 Ways)\",\"datePublished\":\"2024-08-13T17:52:41+00:00\",\"dateModified\":\"2024-08-14T08:37:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel\"},\"wordCount\":994,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png\",\"keywords\":[\"how to combine first and last name in excel\",\"how to combine first name middle name and last name in excel (using formula)\"],\"articleSection\":[\"Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel\",\"name\":\"How to Combine First and Last Name in Excel?- (4 Ways)\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png\",\"datePublished\":\"2024-08-13T17:52:41+00:00\",\"dateModified\":\"2024-08-14T08:37:03+00:00\",\"description\":\"Mastering the tactics specified in this blog will help you to combine first and last name in Excel, improve your data handling capabilities.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png\",\"width\":550,\"height\":309,\"caption\":\"Combine First and Last Name in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Combine First and Last Name in Excel?- (4 Ways)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Combine First and Last Name in Excel?- (4 Ways)","description":"Mastering the tactics specified in this blog will help you to combine first and last name in Excel, improve your data handling capabilities.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel","og_locale":"en_US","og_type":"article","og_title":"How to Combine First and Last Name in Excel?- (4 Ways)","og_description":"Mastering the tactics specified in this blog will help you to combine first and last name in Excel, improve your data handling capabilities.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2024-08-13T17:52:41+00:00","article_modified_time":"2024-08-14T08:37:03+00:00","og_image":[{"width":550,"height":309,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Combine First and Last Name in Excel?- (4 Ways)","datePublished":"2024-08-13T17:52:41+00:00","dateModified":"2024-08-14T08:37:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel"},"wordCount":994,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png","keywords":["how to combine first and last name in excel","how to combine first name middle name and last name in excel (using formula)"],"articleSection":["Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel","name":"How to Combine First and Last Name in Excel?- (4 Ways)","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png","datePublished":"2024-08-13T17:52:41+00:00","dateModified":"2024-08-14T08:37:03+00:00","description":"Mastering the tactics specified in this blog will help you to combine first and last name in Excel, improve your data handling capabilities.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/08\/Combine-First-and-Last-Name-in-Excel-1.png","width":550,"height":309,"caption":"Combine First and Last Name in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/combine-first-and-last-name-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Combine First and Last Name in Excel?- (4 Ways)"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/8649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=8649"}],"version-history":[{"count":4,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/8649\/revisions"}],"predecessor-version":[{"id":8658,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/8649\/revisions\/8658"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/8650"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=8649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=8649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=8649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}