Auto Replace Text after Pasting

[shanenavy26]

When I "Paste as Value". I would like to have the text automatically replace itself to something new in the same cell.

IE: "POS DEBIT - MCDONALDS" --> *Paste into cell* --> "MCDONALDS".

I cannot seem to find a function to fit this once I paste it. Is there a VBA script to help? I will be pasting all these to Column B.

 

[Fluff]

Glad to help & thanks for the feedback.
However I was obviously not think straight when I supplied that.
This should be better

Private Sub Worksheet_Change(ByVal Target As Range)
   If Intersect(Target, Range("B:B")) Is Nothing Then Exit Sub
   Application.EnableEvents = False
   Target.Replace "ACH Transaction - ", "", xlPart, , False, , False, False
   Target.Replace "POS Debit - Visa Check Card XXXX - ", "", xlPart, , False, , False, False
   Application.EnableEvents = True
End Sub

 

[shanenavy26]

Hello Fluff,

Are you familiar with WPS Spreadsheets? What can I change to make it work on there. I only have Excel at the office, not at home so I have to use WPS when im not at work.

 

[Fluff]

I've never heard of WPS before, so know nothing about it.

 

[shanenavy26]

Basically 99% copy of Microsoft Office, but free. I fixed the problem. I had to resave the file as Macro Enabled. On to the next problem!! Thanks.

 

[lezawang]

sorry i see the issue resolved