User Profile

michaelaskew

Copper Contributor

Joined Jul 18, 2023

2 Posts2 LikesLikes received

View All Badges

User Widgets

Recent Discussions

Re: Need to break up 1 cell into multiple columns (text has multiple conditions)
Certainly, here are the shorter versions of the formulas: Column 1 (Last, First, MI): =LEFT(A1, FIND(" ", A1) - 1) Column 2 (Rank): =MID(A1, FIND(" ", A1) + 1, FIND(" ", A1, FIND(" ", A1) + 1) - FIND(" ", A1) - 1) Column 3 (MAJCOM 123 SQUADRON/OFFICE): =MID(A1, FIND(" ", A1, FIND(" ", A1) + 1) + 1, LEN(A1) - FIND(" ", A1, FIND(" ", A1) + 1)) Regards (external link removed by moderator)
Nov 06, 2023 Place Excel
1.1KViews
0likes
0Comments

Recent Blog Articles

No content to show