我需要替換或替換 excel 行中單個文本字符的第一個實體。
current: B01 TEST TEST TEST A W B 0 A
expected result where first "A" that is on its own is replaced with "|": B01 TEST TEST TEST | W B 0 A
問題是，每一行都有一個單獨分割的字符，但它們都是不同的（一些 A、一些 W、一些 R 等）。我可以使用哪個函式來查找被空格包圍的單個文本字符的第一個實體？
uj5u.com熱心網友回復：
在 Office 365 中，您可以使用=AGGREGATE(15,6,FIND(" "&CHAR(SEQUENCE(26,,65))&" ",A19),1)
舊版本：=AGGREGATE(15,6,FIND(" "&{"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"}&" ",A19),1)
編輯：Mayukh 建議的更好版本
=AGGREGATE (15,6,FIND(" "&CHAR(ROW($65:$90))&" ",A19),1)
uj5u.com熱心網友回復：
這使用 Office 365 LET 和 SEQUENCE 并且不依賴于它是大寫字符。它將替換第一個字符，無論是字母、數字還是特殊字符，其兩側都有空格|：
=LET(rng,A1,
sq,SEQUENCE(LEN(rng)-3),
md,MID(rng,sq,3),
lft,LEFT(md),
rt,RIGHT(md),
REPLACE(rng,MIN(IF((lft=" ")*(rt=" "),sq 1)),1,"|"))
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/473441.html