title: Moving only numbers from one column to adjacent column in excel
body: <p>I have an excel spreadsheet with text and $ amounts in column A, but in different rows. I would like to move only the $ amounts to the adjacent column B. For example, the column looks like this.</p>
  
  <p>The Pool Apache<br>
  Frontis</p>
  
  <p>$2,000<br>
  1</p>
  
  <p>White River<br>
  xiv</p>
  
  <p>$3,000<br>1<p>
  So I would want to move <strong>only</strong> the $ amounts to the adjacent column.</p>
  
  <p>I'm pretty sure this could be done with a formula, and have read a number of similar posts, but can't quite work out the correct formula.</p>