| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a semicolon to the end of a name
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a semicolon to the end of a name
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a semicolon to the end of a name
On Dec 15, 11:05*am, 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! Nevermind; found it! Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I add a semicolon at the end of a name in 400 rows at once | Excel Discussion (Misc queries) | |||
| 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 | |||
| Adding the semicolon automatically in date format | Excel Discussion (Misc queries) | |||
Linear Mode
