Hello
How do i prevent the 2nd Instance of patricular String being Replaced using REPLACE Function
For Eg
Amount 75000.00
ID Number 2229400331
Status Amount Trfd
so i would like to prevent string Amount being replaced in line Status Amount Trfd
using the Below code
I get below result
Your help will be appreciated
NimishK
How do i prevent the 2nd Instance of patricular String being Replaced using REPLACE Function
For Eg
Amount 75000.00
ID Number 2229400331
Status Amount Trfd
so i would like to prevent string Amount being replaced in line Status Amount Trfd
using the Below code
VBA Code:
Dim Strline As String
Strline = Replace(Strline, "Amount", vbCrLf & "AMOUNT")
Strline = Replace(Strline, "ID Number", vbCrLf & "ID NUMBER")
Strline = Replace(Strline, "Status", vbCrLf & "STATUS")
I get below result
Instead ofAMOUNT 75000.00
ID NUMBER 22229400331
STATUS Amount Trfd
AMOUNT Trfd
AMOUNT 75000.00
ID NUMBER 22229400331
STATUS Amount Trfd
Your help will be appreciated
NimishK