Insert <tab> in a phrase with condition

[kjxavier]

Hi! Good Morning!

MS Office 2007

I have a list of details eg:



Mr.Jesus P Perez 995 656 55 4554 949 4
Ms.KirstenC Marrero E 49 8 4 6 4 67 655 7
Mrs.Faye W Smith 9 69 6F5 74 8675 7 46 6
Mr.Herbert V Johnson 55 6 4 4 674 6 47 4 4787
Mr.Daniel J Thomoson 79A 48F 8 4 7668 8 6

I would like to insert a <tab> after all 4th word which starts with a Capital letter (even if the 5th word starts with Alphabet or Numeric)

Result:

Mr.Jesus P Perez<tab> 995 656 55 4554 949 4
Ms.KirstenC Marrero<tab> E 49 8 4 6 4 67 655 7
Mrs.Faye W Smith<tab> 9 69 6F5 74 8675 7 46 6
Mr.Herbert V Johnson<tab> 55 6 4 4 674 6 47 4 4787
Mr.Daniel J Thomoson<tab> 79A 48F 8 4 7668 8 6

Appreciate your early reply!

Thank you

[macropod]

You could use a wildcard Find/Replace, where:
Find = ^13[! .]*[ .][! ]@ [! ]@ [A-Z]*^32
Replace = ^&^t
The data you've posted, though, aren't entirely consistent, as there is no space between the first two words and sometimes between what it appears should be the 2nd & 3rd words. the above F/R code will cope with the first issue but there's no fix for the second issue.