Hi,
I am not an extensive excel user which is why I am here. I need help with a function.
Here is an example of the data I have in A2
set service "XD Port 1" + udp src-port 0-65535 dst-port 138-138
I added the function =REPLACE(A2,13,1,"""source ") so I get
set service "source XD Port 1" + udp src-port 0-65535 dst-port 138-138
I would like to transpose the 0-65535 and the 138-138 so I end up with
set service "source XD Port 1" + udp src-port 138-138 dst-port 0-65535
All the lines I have look similar. The 0-65535 and the 138-138 (or whatever number) are always preceded by src-port and dst-port so I was trying to do a search for that text and then do a copy and paste or something like that.
Thanks for any help.
Bookmarks