title: Identify Capital Letter in grouped words and insert a comma and space
body: <p>I am working on a task where I have to copy/paste the content from website into excel.</p>
  
  <p>But the problem is when I copy/paste the content in excel, it appears like this :</p>
  
  <ul>
  <li>Los AngelesNew YorkSilicon Valley</li>
  <li>Consumer InternetMobileB2BEnterprise SoftwareE-CommerceMarketplacesSocial</li>
  </ul>
  
  <p><code>Let s call Los Angeles an item which is merged with another item New York</code> and I want to separate these items so that information is readable like this: </p>
  
  <ul>
  <li>Los Angeles, New York, Silicon Valley</li>
  <li>Consumer Internet, Mobile, B2B, Enterprise Software, E-Commerce, Marketplaces, Social</li>
  </ul>
  
  <p>When I noticed I actually realized that on website (due to some technical reason) I was unable to copy the comma between items and therefore every other item was merged with a capital letter with previous item.</p>
  
  <p>Now please help me know is there an intelligent way to solve this problem because there are hundred of entries. What I see is this is how this problem can be solved:</p>
  
  <ol>
  <li>Identify a capital letter which is not after a space and has small letter previous to it.</li>
  <li>Insert a comma and space at that place and continue with the remaining string.</li>
  </ol>
  
  <p>Please feel free to elaborate if this won't work and if there is an alternative solution. VBA code/ Excel Formula  - anything that can help me automate it. Thanks.</p>