| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate text
Or you can do it with a simple macro:
Sub insdup() For ancell = 4 To 2 Step by - 1 ' replace 4 by real No of rows Rows(ancell).Copy Rows(ancell + 1).Insert Shift:=xlDown Application.CutCopyMode = False Next ancell End Sub Regards, Stefi €˛Kiannie€¯ ezt Ć*rta: I want to duplicate names, example : Dog Cat Duck duplicate to Dog Dog Cat Cat Duck Duck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete duplicate then combine text | Excel Discussion (Misc queries) | |||
| Duplicate text values | Excel Worksheet Functions | |||
| Duplicate text values | Excel Worksheet Functions | |||
| duplicate text | Excel Discussion (Misc queries) | |||
| How do I get rid of duplicate text? | Excel Worksheet Functions | |||
Threaded Mode
