Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Everyone
I have a speadsheet with columns of credit card transactions. Column B contains the name & address of the retailers as show below: FOODLAND PARKLAND PAR SAMS SEAFOOD RICHMOND PAR SHELL SELF SERVE ELIZABETH VLE DICK SMITH W8080 ELIZABETH CIT How do I Find and Replace all instances of PAR on the right hand end of cell with PARK without changing PARKLAND to PARKKLAND with two "K's" ?. TIA Bob C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and replace macro | Excel Discussion (Misc queries) | |||
Macro to Find and Replace | Excel Discussion (Misc queries) | |||
Macro to Find & Replace | Excel Worksheet Functions | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) |