Thread: Relpace entire address with street name only, searching with wildc
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oldchippy oldchippy is offline
external usenet poster
  
Posts: 1
Default Relpace entire address with street name only, searching with wildc

Hello bclancy12,

Why not try Find Replace

ie. Find "Main Street" then Replace "Main"

then Find "Main Ste" then Replace "Main"

oldchippy


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569142

Reply With QuoteReply With Quote