| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I add a semicolon at the end of a name in 400 rows at once
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I add a semicolon at the end of a name in 400 rows at once
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 EditPaste SpecialValuesOKEsc Delete original column A. Curious.............why would you need a semi-colon at end of each name? Gord Dibben MS Excel MVP On Sat, 19 May 2007 20:21:00 -0700, mike wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I add a semicolon at the end of a name in 400 rows at once
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hi, mike !
OMG MIKE... That was awesome, easy, and so cool. Thank you SOOOOOO MUCh.
On Saturday, May 19, 2007 11:21 PM mik wrote: 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 EditPaste SpecialValuesOKEsc Delete original column A. Curious.............why would you need a semi-colon at end of each name? Gord Dibben MS Excel MVP On Sat, 19 May 2007 20:21:00 -0700, mike wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT - comma versus semicolon | Excel Worksheet Functions | |||
| SUMPRODUCT --- semicolon (;) vs. plus sign (+) | Excel Worksheet Functions | |||
| how do i make a semicolon appear in every cell | Excel Discussion (Misc queries) | |||
| I need to place the semicolon in my draft how is it done? | Excel Worksheet Functions | |||
| creating a list from a column of semicolon | Excel Discussion (Misc queries) | |||
Hybrid Mode
