View Single Post
  #1   Report Post  
Herman
 
Posts: n/a
Default extract specific info from cells in a column

how do I extract specific info within a cell ie 73AP9 and 73AP7 from column
ranged B1:B200 on sheet 1 and have show up on sheet 2 in a specific row
under 2 separate columns 1 for each entry, ie row is titled 73A looking to
put the 73AP9 and 73AP7 in their own column within the row label 73A