Hi,
Let's say the names are in cell A1 all the way down in B1 enter

=A1&";"
copy the formula down

" wrote:

Hello - I have a thousand names or so in a data sheet and need to add
a semi - colon after each name. Is there a quick way that I can do
this?

For example:

Do, John

needs to look like:

Do, John;

Thanks!