Tips & Tricks 201 – Remove Numbers from Strings

To remove numbers from a string, for a single cell

=CONCAT(TEXTSPLIT(A2, SEQUENCE(10,,0)))

Using REGEX

=REGEXREPLACE(A2, "[0-9]", "")

To remove numbers from entire range

=BYROW(A2:A10, LAMBDA(a, CONCAT(TEXTSPLIT(a, SEQUENCE(10,,0)))))

using REGEX

=REGEXREPLACE(A2:A10, "[0-9]", "")

The Excel file for this tip can be downloaded from Tips & Tricks 201 – Remove Numbers from a String

6 thoughts on “Tips & Tricks 201 – Remove Numbers from Strings”

🔇 You got a transfer from us. Confirm =>> https://graph.org/GET-BITCOIN-TRANSFER-02-23-2?hs=b8905b238b636bd4dc1ae63f1bda42ff& 🔇 says:

March 20, 2025 at 10:29 am

ea57cm

Reply
🖇 Ticket- Transfer №YZ97. NEXT => https://graph.org/GET-BITCOIN-02-25?hs=b8905b238b636bd4dc1ae63f1bda42ff& 🖇 says:

March 21, 2025 at 1:43 pm

mcukqg

Reply
🔇 Notification: + 1.280310 BTC. GET >> https://graph.org/Message--05654-03-25?hs=b8905b238b636bd4dc1ae63f1bda42ff& 🔇 says:

April 3, 2025 at 2:14 am

y01ay0

Reply
droversointeru says:

April 4, 2025 at 1:16 am

Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!

Reply
📈 + 1.207306 BTC.NEXT - https://graph.org/Message--685-03-25?hs=b8905b238b636bd4dc1ae63f1bda42ff& 📈 says:

April 4, 2025 at 7:51 am

7yau6o

Reply
📣 + 1.281053 BTC.GET - https://graph.org/Message--0484-03-25?hs=b8905b238b636bd4dc1ae63f1bda42ff& 📣 says:

April 10, 2025 at 4:36 am

6oci6k

Reply