0
votes
2answers
26 views

How do I replace cells in Column A of Excel if the column I'm pulling from is partially blank?

I have an old list of names in Column A, and I want to replace them with the update names in Column B. What function can I use to replace only the cells that need updating? I basically want to keep ...
0
votes
0answers
70 views

Replacing values and calculating a text field

I am stuck up at work and need someone's help. Actually I have a huge table of some conditions like: 55x(x-1)(x-2)(x+3)(x+4) 55x(x-1)(x-2)(x-2)(x-2)(x-2) 55x5555x 55xx(x+1)(x+1)(x+2)(x+2) ...
0
votes
3answers
815 views

Excel or Batch - Trying to Automate Text Correction (Many Changes; One or More Characters Each)

I have a lot of lines of text. I can put them into a text file or into an Excel spreadsheet. They need many changes. Here's an example of a before and after: Input: I'm buying one! Only ...
0
votes
2answers
6k views

Excel macro: Replace enitre cell contents; replace 1 but not 10, 11, 21 etc

I need to replace a large amount of numbers with words in an Excel spreadsheet. Eg: 1 = hello 12 = goodbye 4 = cat etc. I can do it with the standard search and replace, but i have a large list to ...