+ Reply to Thread
Results 1 to 4 of 4

Copy / Paste Function

  1. #1
    Registered User
    Join Date
    05-04-2006
    Posts
    91

    Copy / Paste Function

    a1: EDCU-1334A


    Trying to copy and paste this so the result will be

    a2 : EDCU-1334B
    a3 : EDCU-1334C
    a4 : EDCU-1334D

    Just trying to make it quicker to populate instead of having to retype everything out.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Copy / Paste Function

    Go to Option, Advanced > General > Edit Custom List > Add a custom list (A,B,C....,Z)

    In cell A1 Type EDUC-1334 (Copy it down without fill series). In Cell B1, Type A then drag it down. In Cell C1, type =A1&B1 then drag it down

  3. #3
    Forum Contributor
    Join Date
    09-16-2009
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel XP, 2003, 2010
    Posts
    125

    Re: Copy / Paste Function

    Hi there,

    what JieJenn described would work but just dragging the first cell (A1) with the value EDUC-1334A down the column and filling series should work also.

    hope this helps,
    Fidd$

  4. #4
    Forum Contributor
    Join Date
    09-16-2009
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel XP, 2003, 2010
    Posts
    125

    Re: Copy / Paste Function

    incorrect solution by me. tried to edit and delete but no joy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1