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