Forum Discussion
I could use help trying to replace data in the same cell.
Hi, I looked online and tried substitute but that didn't give me anything I could copy/paste in a field. I tried replace but the macro wouldn't work because I couldn't setup the index. I have mu...
again, samples and such would help a lot. But the sounds of it is that you don't necessarily need it replaced in the SAME cell. Wouldn't it be easier to paste the data into A1 and have the formula in A2 and then copy and paste the result from A2 back into your system? Of you could have the input on Sheet1 and the output on Sheet3 so then you can export or save that sheet?
More than likely it IS possible, the question is WHAT it is that is possible.
More than likely it IS possible, the question is WHAT it is that is possible.
The issue is I have 670+ cells I have to do this on. I will have additional data pulls incoming. I was looking to see if I could speed it up. Sheet 2 has no real bearing on the task but it is what I use to find duplicate names through multiple requests. It saves the time of repeatedly looking up NTIDs.
- I don't even know if I understand what "this" is. You have in the example
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
But I assumed that was indicative of many different individuals with different last names, first name and job titles and that on sheet2 was the same thing that there is a list of each name and replacement value. but now I don't know, is it the same name repeated?
As for the 670+ cells, fine, you have a formula that does what you need and you put those 670+ in cells A1:A670 and the formula in B1:B670 (or use dynamic arrays to apply the 1 formula to the whole set)
but like I said, it is hard to help if I don't understand what you need.