title: In VBA, looking to clean up data that has merged into the same cell
body: <p><a href="https://i.stack.imgur.com/URECc.jpg" rel="nofollow noreferrer">Reference data</a></p>
  <p>Hello all,</p>
  <p>I'm looking to seperate some data that is merging upon copy/paste of a word document.</p>
  <p>In my B column, I have a set of capitol letters and integers that I would like to keep in the same column. For some data, I have a description being merged in as well but is always separated out by a space. I would like to go through the rows, look for a space, if a space is noted to cut the columns C:J of that row and push them back (to the right) one row. Then, paste the values after the space in column B to the blank column C.</p>
  <p>Appreciate any help!</p>