Results 1 to 50 of 50

Move cells based on cell length *shift cells right) - code required

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,702

    Move cells based on cell length *shift cells right) - code required

    Hi

    I have a database which when I export to excel it doesnt always come out in the same format.

    e.g.
    AT Business 1 1
    AU Business 2 2
    AV Business 3 3
    AW Business 4 4
    AX Business 5 5
    AY Business 6 6
    AZ Business 7 7
    BABusiness 8 8
    BBBusiness 9 9

    What I would like is a macro that looks at the cell lenth in column A.
    If it is 2 or less then do nothing.
    But, if it is more than two characters then I need it to put the first two characters in column one and then the remaining contents in column B (apart from the space) and shifting everything else along.

    It would then look like this:
    AT Business 1 1
    AU Business 2 2
    AV Business 3 3
    AW Business 4 4
    AX Business 5 5
    AY Business 6 6
    AZ Business 7 7
    BA Business 8 8
    BB Business 9 9

    Can anyone help with the code please?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help Required - Concatenating cells contents into single cell, based on an ID
    By mharis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2013, 07:49 AM
  2. Replies: 0
    Last Post: 03-26-2013, 02:58 PM
  3. Replies: 3
    Last Post: 11-06-2012, 11:26 AM
  4. Recognizing a cell has a number or a zip code, if so shift cells to the right
    By ej463 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-17-2009, 01:06 PM
  5. [SOLVED] Move/Shift cells left or right in a row
    By T.Taylor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2005, 11:20 AM

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