LinkBack URL
About LinkBacks
B1=LEFT(A1,SEARCH({"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"},A1,2)-1)
This is an array formula.
Close with CTRL+SHIFT+Enter.
The brackets appear automaticly.
B1=LEFT(A1,SEARCH({"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"},A1,2)-1)
This is an array formula.
Close with CTRL+SHIFT+Enter.
The brackets appear automaticly.
Last edited by oeldere; 05-26-2022 at 02:43 PM. Reason: add A -Z
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks