Tips & Tricks 201 – Remove Numbers from Strings

Posted on September 22, 2024November 5, 2024 by Vijay Verma

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

10 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
📕 + 1.575904 BTC.GET - https://graph.org/Message--0484-03-25?hs=b8905b238b636bd4dc1ae63f1bda42ff& 📕 says:

April 18, 2025 at 7:16 pm

imfgz0

Reply
creaci n de dashboard con power bi says:

April 23, 2025 at 8:38 pm

Attractive part of content. I simply stumbled upon your website and in accession capital to say that I get actually loved account your weblog posts. Anyway I’ll be subscribing to your augment and even I fulfillment you get admission to constantly rapidly.

Reply
📕 + 1.124960 BTC.NEXT - https://graph.org/Binance-04-15?hs=b8905b238b636bd4dc1ae63f1bda42ff& 📕 says:

April 24, 2025 at 11:42 pm

303zlw

Reply
🛠 Reminder: TRANSFER 1,629663 BTC. Confirm >> https://graph.org/Message--685-03-25?hs=b8905b238b636bd4dc1ae63f1bda42ff& 🛠 says:

April 27, 2025 at 2:44 pm

5gf7p5

Reply

Leave a Reply Cancel reply

[accordian][toggle title="Our Company Mission"]Fugiat dapibus, tellus ac cursus commodo, mauris sit condim eser ntumsi nibh, uum a justo vitaes amet risus amets un. Posi sectetut amet fermntum orem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia nons.[/toggle] [toggle title="The Avada Philosophy"]Fugiat dapibus, tellus ac cursus commodo, mauris sit condim eser ntumsi nibh, uum a justo vitaes amet risus amets un. Posi sectetut amet fermntum orem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia nons.[/toggle] [toggle title="The Avada Promise"]Fugiat dapibus, tellus ac cursus commodo, mauris sit condim eser ntumsi nibh, uum a justo vitaes amet risus amets un. Posi sectetut amet fermntum orem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia nons.[/toggle] [toggle title="We Can Deliver On Projects"]Fugiat dapibus, tellus ac cursus commodo, mauris sit condim eser ntumsi nibh, uum a justo vitaes amet risus amets un. Posi sectetut amet fermntum orem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia nons.[/toggle][/accordian]