Adding a semicolon to the end of a name

[jesoldano]

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!

 

[Eduardo]

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

=A1&";"
copy the formula down

 

[jesoldano]

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!

Nevermind; found it! Thanks