Harry0
Member
MS office has the ability to replace with special options, but can excel do that too?
What the wild card is the * or ?? but what if I want to keep a random number that it finds what do I use? *ignore*?
For example 2 lines that state
,IF(K4="","",VLOOKUP(K4,'Full List'!$A$2:$G$2000,4))
with
,VLOOKUP(K4,'Full List'!$A$2:$G$2000,4)
only the beginning and the end would be removed while the rest is kept.
,IF(K4="","".....................................)
Another twist would be to switch
vlookup(a1, b1:c2,1)
vlookup(a2, b1:c2,2)
I want the replace options to change it to be
index(b1:c2, a1,1
index(b1:c2, a2,2
It would be a combination of replace and offset.
I would need an excel formula within the excel replace command. LOL
Usually I do this with various methods but excel like to prevent me to do it my way and gives me errors. Another way would be a non excel approach which I do not want to mess with hex editors at the moment on a limited computer that can't handle it, or use old outdated programs that can handle it with a combination of other tools to exchange code between various outdated programs to do the job.
What the wild card is the * or ?? but what if I want to keep a random number that it finds what do I use? *ignore*?
For example 2 lines that state
,IF(K4="","",VLOOKUP(K4,'Full List'!$A$2:$G$2000,4))
with
,VLOOKUP(K4,'Full List'!$A$2:$G$2000,4)
only the beginning and the end would be removed while the rest is kept.
,IF(K4="","".....................................)
Another twist would be to switch
vlookup(a1, b1:c2,1)
vlookup(a2, b1:c2,2)
I want the replace options to change it to be
index(b1:c2, a1,1
index(b1:c2, a2,2
It would be a combination of replace and offset.
I would need an excel formula within the excel replace command. LOL
Usually I do this with various methods but excel like to prevent me to do it my way and gives me errors. Another way would be a non excel approach which I do not want to mess with hex editors at the moment on a limited computer that can't handle it, or use old outdated programs that can handle it with a combination of other tools to exchange code between various outdated programs to do the job.