Extract Left Of A Upper Case Letter

[gr8whthunter76]

When I copy and paste a name from pdf to excel the name gets all mushed together, not sure why. No matter which paste function I use, can't get things to work. For example, Private Joe Snuffy in pdf becomes PrivateJoeSnuffy when you copy from pdf to excel. If I paste that name in A1,PrivateJoeSnuffy, is there a formula to break the name back apart? I would assume there has to be some sort of formula to extract between upper case letters maybe? I've even tried exporting to excel but then you run into another problem is that excels puts a space between each letter so Private Joe Snuffy becomes P r i v a t e J o e S n u f f y which is an easy fix using =SUBSTITUTE(A1," ","").............but then you are back to square one lol, PrivateJoeSnuffy.

 

[hagia_sofia]

Hello, would this work for you:

=LET(
a,A1,
b,MID(a,SEQUENCE(LEN(a)),1),
TRIM(TEXTJOIN("",,IF(EXACT(b,UPPER(b))," "&b,b))))