Forum Discussion
Adding a symbol to an existing column of names
I want to add a symbol to the end of a column of names so that I can distinguish this list of names from another when uploading to a software program. I tried adding a column with a symbol in it and...
Sorry for my stupidity, I still didn't catch. Perhaps you may submit small sample file to illustrate, not with 2000 records, just 2 will be enough. What do you have and what you'd like to have as result.
If you'd like to add any symbol to values in list 2, doesn't matter which one, you may do that with formula in another column, copy and paste it back as values in initial column. Or use VBA to modify values in place.
Or something else?
I will research what VBA is but in the meantime here is an example:
What it looks like now What I want it to look like
John Smith John Smith*
Mary Jones Mary Jones*
Robert Macks Robert Macks*
What it looks like now What I want it to look like
John Smith John Smith*
Mary Jones Mary Jones*
Robert Macks Robert Macks*