CODEWITHSUNDEEP
regexgoogle-sheetsgoogle-sheets-formulatext-extraction
F H
F H

Reputation: 43

How to extract word between number and a comma in a string

How do I extract "Seri Kembangan" in googlesheet?

Farm In The City, Lot 40187-40188, Jalan Tropika Barat 1, Pusat Bandar Putra Permai, 43300 Seri Kembangan, Selangor

Upvotes: 1

Views: 136

Answers (2)

player0
player0

Reputation: 1

try:

=REGEXEXTRACT(A1, "\d+ (.+),")

enter image description here

Upvotes: 1

Aresvik
Aresvik

Reputation: 4620

Try:

=regexextract(A1,"\d\ (.*),")

Upvotes: 0

Related Questions