View Single Post
 
Old 08-01-2014, 07:54 PM
kjxavier kjxavier is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Lightbulb 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
Reply With Quote