View Single Post
  #1   Report Post  
jade89 jade89 is offline
Junior Member
 
Posts: 1
Default Picking out certain data from a cell

How do i pick out from within a cell those that have a certain character? In my case, from this cell below: I would like to pick out only #01-034.

#01-034 EAST AVENUE

Is there a way to do this?