Adding a semicolon to the end of a name

J

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!
 
E

Eduardo

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

=A1&";"
copy the formula down
 
J

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!
Click to expand...

Nevermind; found it! Thanks
 
Top