title: excel search range for specific text copy cell containing text
body: <p>I need some assistance with an excel spreadsheet. I'm not very proficient with excel and not familiar with excel-vba but I'm open to suggestions and willing to learn to get this to work properly.</p>
  
  <p>I need to have a formula search a range of columns and pull only the one containing the required information into a new column but keep the original row #.</p>
  
  <p><a href="https://i.stack.imgur.com/MCWws.jpg" rel="nofollow noreferrer">Example of spreadsheet</a><br/>  <a href="https://i.stack.imgur.com/MCWws.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MCWws.jpg" alt="enter image description here"></a></p>
  
  <p>I found the below which sort of does what I'm looking for but it's only for a single column. How can I make it search a range of cells &amp; copy only the one containing the identifying character ie (h), (c), or (w) to pull it to the appropriate column.</p>
  
  <p><a href="https://stackoverflow.com/questions/26199891/copy-a-cell-if-another-cell-contains-a-specific-text-string">Copy a cell if another cell contains a specific text string</a></p>
  
  <p>How do I use a formula to search the range of cells containing the phone numbers then pull the one cell containing (h) under home and so on for the others. I need the number to remain in the same row so it stays assigned to the correct contact when uploaded as well.</p>
  
  <p>I'm trying to organize phone numbers into select columns from a range of cells. </p>
  
  <p>I have a list of phone numbers that when pulled from the database are drop into a single cell, I use text to column to spread it so each number is in its own cells. From here I need to organize it so each number is copied under the appropriate field Home, Work, Cell. </p>