+ Reply to Thread
Results 1 to 2 of 2

Copy and paste sequential alpha numeric entries

  1. 01-12-2015, 06:24 PM #1
    Coral-Reefer
    Coral-Reefer is offline
    Registered User
    Join Date
    05-16-2013
    Location
    Newland, NC
    MS-Off Ver
    Excel 2013
    Posts
    16

    Copy and paste sequential alpha numeric entries

    I used to know this but have forgotten.

    I have three cell entries:

    6P1P
    6P2P
    6P3P

    I want to paste them sequentially down a column so that they appear down the column as:

    6P4P
    6P5P
    6P6P, etc.

    Thanks in advance for any help.

    Chris
    Reply With QuoteRegister To Reply
  2. 01-13-2015, 03:34 AM #2
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Copy and paste sequential alpha numeric entries

    maybe you can do it like this instead

    ="6P"&ROW(3:3)&"P" -> drag formula down
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generate a range of sequential alpha numeric codes based on a from and to value
    By kenny.fsw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2013, 09:53 AM
  2. Sort The list of items by Alpha / numeric in their proper sequential order
    By DON_BLACK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 03:42 PM
  3. [SOLVED] Sequential Alpha numeric code in batches, with spaces
    By joee74 in forum Excel General
    Replies: 5
    Last Post: 03-12-2013, 09:33 AM
  4. alpha numeric data auto copy
    By tldsog in forum Excel General
    Replies: 2
    Last Post: 02-08-2013, 07:26 AM
  5. Extract alpha name with spaces from a mixed alpha-numeric string
    By kdigit0l in forum Excel General
    Replies: 2
    Last Post: 06-18-2010, 05:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1