Forum Discussion
extracting car plate from cell
I have to extract car plate from bank reference column. there are more than 10000 lines per month. The position of the car plate in the string varies. The car plate has min of 5 and max 10 alphabet+ ...
FILTERXML(), TEXTSPLIT(), TEXTAFTER(), TEXTBEFORE() all these function may help you. Please post few sample data and show your desired output so that we can put formula for you.
- Jun 25 2024 01:01 AM
- WHK 88966W8011VB/EE/88966W8011VB/PD/ S1464157B TRUSTY TO WONG HEA KONG EXCESS REFUND SGD 1,000.00 SMJ7093D JTEGD56M007150803
- SEOW KENG SENG /EE/SLF2195J/PD/OTHR /IREF/20240617DBSSSGSGBRT5155443//PAYNOW Others
Car Plate: SMJ7093D, SLF2195J
Above are two sample. Most of the references have the similar pattern.
