How can I add a semicolon at the end of a name in 400 rows at once

[mike]

I have created a worksheet with 410 names and forgot to put a semicolon at
the end of each line. I need to place one there now and either have to do it
individually or ??? please any one out there that can help me, respond. I am
running microsoft exell 2003, on a PC.

 

[Gord Dibben]

Assuming names are in column A

In B1 enter =A1 & ";"

Double-click on the fill handle of B1 to copy down.

When happy, copy column B and in place Edit>Paste Special>Values>OK>Esc

Delete original column A.

Curious.............why would you need a semi-colon at end of each name?


Gord Dibben MS Excel MVP

 

[Héctor Miguel]

hi, mike !

I have created a worksheet with 410 names and forgot to put a semicolon at the end of each line.
I need to place one there now and either have to do it individually or ???
please any one out there that can help me, respond. I am running microsoft exell 2003, on a PC.

assuming 410 names in [A1:A410] (or modify as needed)

- open vba-editor -> shortcut: {Alt}+{F11}
- show immediate window -> shortcut: {Ctrl}+G
- type the following and press {Enter}
[a1:a410] = evaluate("a1:a410&"";""")

hth,
hector.

 

[brigette medina]

OMG MIKE... That was awesome, easy, and so cool. Thank you SOOOOOO MUCh.

I have created a worksheet with 410 names and forgot to put a semicolon at
the end of each line. I need to place one there now and either have to do it
individually or ??? please any one out there that can help me, respond. I am
running microsoft exell 2003, on a PC.

On Sunday, May 20, 2007 12:02 AM Gord Dibben wrote:
Assuming names are in column A

In B1 enter =A1 & ";"

Double-click on the fill handle of B1 to copy down.

When happy, copy column B and in place Edit>Paste Special>Values>OK>Esc

Delete original column A.

Curious.............why would you need a semi-colon at end of each name?


Gord Dibben MS Excel MVP

On Sunday, May 20, 2007 12:11 AM Héctor Miguel wrote:
hi, mike !


assuming 410 names in [A1:A410] (or modify as needed)

- open vba-editor -> shortcut: {Alt}+{F11}
- show immediate window -> shortcut: {Ctrl}+G
- type the following and press {Enter}
[a1:a410] = evaluate("a1:a410&"";""")

hth,
hector.