Coping values

[Rnash]

Question. I have a list of about 20,000 names. The original data is in column C. I ran a formula in column D to move the suffix from one position within the names that have a suffix to the end position of the cells in column C. My issue is that not all names returned a result because not all names have a suffix (jr. sr. ect.). So I now have the corrected values in column D. Is there a way to overwrite the original name in Column C with what was returned without having to do it one by one?

[martindwilson]

i think yo maybe should have posted samples of all your variants in the first place

[Rnash]

Think I just figured it out. I believe I need to run the formula the entire column and not just on a filtered list. Sorry for the confusion.