View Single Post
  #10  
Old 20th June 2014, 10:22 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,457
Default

Not really an issue, a formula like this can be used to manipulate data stripping out what's not needed and formulating it for Gruss to be searched

=AI5&". "&SUBSTITUTE(RIGHT(AC5,LEN(AC5)-FIND(" ",AC5,1)),"'","")

The thing you find is late scratchings are not removed but have a tag of (NR) after the name, still no drama with searching.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote