seperating

[ntudev]

Hello,

I need help separating the names from the previous numbers and some letters with numbers, i just want to see the names in a new column is that possible?

115972545 John Doe

1584575 Mary Jame

87575285 Robert Bum

582486548 Julie Ostim

CIS 1575485 Jane Doe

5415545 Niles West

BB15415524 West Nile

G1542745 George Ten

[Felipe_Ribeir0 · Accepted solution]

Hi @ntudev 

Try this regex formula:

REGEX_Replace([Input], '^.*?\s?(\D+)$', '$1')