I have a column with data somewhat similar to the values below. I would like to pull the 10 character values (i.e. PGHK000580, MVHK001582, PGTW000427, PFHK001535, ZOHK001596 etc.) within each row and append it as a new column.
Would appreciate any help I can get from the community. Thanks in advance!
PGHK000580 TEXT 1234567890
MVHK001582 TEXT 3 4 5
PFHK001535 TEXT 5 6 7