I have a file containing about 30k business names. In order to import this into another program the name must not exceed 35 characters. Can I break the name into two cells at the last space before the 35 character limit within the name is reached? For example:

Column A: Cardiovascular Diseases & Interventional Cardiology
Column B: Cardiovascular Diseases &
Column C: Interventional Cardiology