1b:T6d3,{"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":{"@type":"WebPage","@id":"/x/community/kcnwkrnzzq1t/how-to-split-full-name-column-into-first-and-last"},"headline":"How to Split Full Name Column into First and Last Name in Excel","text":"

Hi guys, how I do I split a full name columns into two columns, first and last name

","url":"/x/community/kcnwkrnzzq1t/how-to-split-full-name-column-into-first-and-last","author":{"@type":"Person","name":"Corey G.","url":"/user/e48d9d7e-49b1-415a-9a89-51e2aed9bef7"},"datePublished":"2025-02-08T18:12:28.795214+00:00","dateModified":"2025-02-10T17:11:17.210143+00:00","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},"comment":[{"@type":"Comment","text":"

formula should work, where you can for example prompt it to just split on the first space

","author":{"@type":"Person","name":"Fabian H.","url":"/user/ea85b427-a888-4d7a-ab41-4b7cc32fc6bc"},"datePublished":"2025-02-08T18:23:13.063316+00:00","dateModified":"2025-02-08T18:23:13.063316+00:00","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0}},{"@type":"Comment","text":"

Hey Vatsal! Voltic.agency , We provide expert VAs with a strong background and working experience at cost-effective rates. (Mehmona)

","author":{"@type":"Person","name":"Mahmona","url":"/user/302ddeb1-8229-4d43-8a8f-f1cf483fd8ab"},"datePublished":"2025-02-10T17:11:16.264318+00:00","dateModified":"2025-02-10T17:11:16.264318+00:00","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0}}]}9:["$L1a",["$","script",null,{"type":"application/ld+json","dangerouslySetInnerHTML":{"__html":"$1b"}}]]

2 comments