Insert <tab> in a phrase with condition
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
|