+ Reply to Thread
Results 1 to 7 of 7

splitting cells in column

  1. 01-22-2015, 02:33 PM #1
    uday1969
    uday1969 is offline
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    splitting cells in column

    Hi Guru's

    In column A - I have number of cells like
    0000DS_GL_RPE
    01061000AAZREGOFC
    0000DS_GL_RSL
    01061000AAZREGOFC
    0000DS_GL_RME
    01061000AAZREGOFC
    0000DS_GL_RSL
    01061000ALAREGOFC
    0000DS_GL_RSL
    01061000ALAREGOFC

    I would like have second cell or alternative one to be in column B

    Please advise for the formula.

    Regards
    Odaiah
    Reply With QuoteRegister To Reply
  2. 01-22-2015, 02:50 PM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: splitting cells in column

    b1=index(a:a,row(a1)*2)
    or
    b1=index(a:a,row(a1)*2-1)
    try this and copy towards down
    if it is not you are looking for attach sample file with desired result
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 01-27-2015, 05:56 PM #3
    uday1969
    uday1969 is offline
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: splitting cells in column

    Hi

    It is solved the issue but I need delete from column A which I copied to column B. I don't want duplicated in columns.

    Regards
    Odaiah
    Reply With QuoteRegister To Reply
  4. 01-27-2015, 06:06 PM #4
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: splitting cells in column

    Why not just use both of Siva's formulae in B1 & C1 then copy B & C, paste back to B1 as values and delete column A.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  5. 01-27-2015, 06:49 PM #5
    uday1969
    uday1969 is offline
    Registered User
    Join Date
    06-13-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    70

    Re: splitting cells in column

    Hi

    01061000AAZREGOFC
    01061000AAZREGOFC
    01061000AAZREGOFC
    01061000ALAREGOFC

    I need to delete the numbers I need only AAZREGOFC. Please advise me.

    Regards
    Odaiah Pelley
    Reply With QuoteRegister To Reply
  6. 01-27-2015, 07:12 PM #6
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: splitting cells in column

    Quote Originally Posted by uday1969 View Post
    Hi

    01061000AAZREGOFC
    01061000AAZREGOFC
    01061000AAZREGOFC
    01061000ALAREGOFC

    I need to delete the numbers I need only AAZREGOFC. Please advise me.

    Regards
    Odaiah Pelley
    Hi,

    Maybe you should have mentioned that in your first post.
    Reply With QuoteRegister To Reply
  7. 01-27-2015, 07:14 PM #7
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: splitting cells in column

    ...in that case an extension of Siva's formula

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    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] Splitting multi-line cells into rows and moving the values into another column
    By Gav74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2013, 09:59 AM
  2. Splitting a cell with multiple words into a column of cells with one word.
    By Cr4zYb00 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2013, 03:39 PM
  3. Searching multiple cells in a column, splitting on a " vs " string and doing a bit of Math
    By ds2000 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-08-2012, 04:54 AM
  4. Splitting cells from one column to two columns
    By zachharriman in forum Excel General
    Replies: 1
    Last Post: 04-02-2008, 03:40 PM
  5. [SOLVED] Copy cells without splitting column
    By VJ in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-09-2005, 02:06 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