In the example case below, let’s select “Delimited” so we can separate the full name into first name and last name.<\/p>\n\n\n\n
Then, it’s time to choose the Delimiters. This could be a tab, semi-colon, comma, space, or something else. (“Something else” could be the “@” sign used in an email address, for example.) In our example, let’s choose the space. Excel will then show you a preview of what your new columns will look like.<\/p>\n\n\n\n
When you’re happy with the preview, press “Next.” This page will allow you to select Advanced Formats if you choose to. When you’re done, click “Finish.”<\/p>\n\n\n\n Ref: https:\/\/blog.hubspot.com\/marketing\/how-to-use-excel-tips<\/p>\n","protected":false},"excerpt":{"rendered":" What if you want to split out information that’s in one cell into two different cells? For example, maybe you want to pull out someone’s company name through their email address. Or perhaps you want to separate someone’s full name into a first and last name for your email marketing templates. Thanks to Excel, both Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[10,18],"tags":[505,504],"class_list":["post-2810","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-split-text","tag-split-text-on-excel"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t![\"Text](\"https:\/\/blog.hubspot.com\/hs-fs\/hub\/53\/file-2420726051-gif\/Text_to_Column_GIF.gif?width=600&name=Text_to_Column_GIF.gif\" "\\"Text")
<\/figure>\n\n\n\n