I have list of names and i am tryign to extract the First word then First character of 2nd word and 3rd character of 3rd work and so on…
I was only able to make this formula but it works till 2nd name how to achieve further any help will be much appreciated.
=LEFT(D4,FIND(" ",D4)-1)&" "&LEFT(LEFT(D4,SEARCH(" ",D4)-1),1)
[enter link description here][2]
[2]:
>Solution :
try:
=ARRAYFORMULA(IFNA(REGEXEXTRACT(B2:B, "\w+ ")&
BYROW(B2:B, LAMBDA(x, TEXTJOIN(, 1, IFNA(REGEXEXTRACT(
SPLIT(REGEXREPLACE(x, "^(\w+) ", ), " "), "[A-Z]"))))))
update:
=ARRAYFORMULA(IFNA(TRIM(REGEXEXTRACT(B2:B, "\w+")&" "&
BYROW(B2:B, LAMBDA(x, TEXTJOIN(, 1, IFERROR(REGEXEXTRACT(
SPLIT(REGEXREPLACE(x&" ", "^(\w+) ", ), " "), "[A-Z]"))))))))
