+ Reply to Thread
Results 1 to 8 of 8

cell separation

  1. #1
    Registered User
    Join Date
    02-15-2019
    Location
    Athens, Greece
    MS-Off Ver
    2013
    Posts
    32

    cell separation

    Hello i have a question.

    How can i separate a cell in multiple cells to the right by using as a criteria "," ?

    First example goes like this 64585868676, 4859859898569, 58595895

    The second criteria is a little bit more complex.

    Let's say i have two addresses like:
    Garden avenue, Athens, 15562, Skra 55, Holargos, 16785

    I would like to separate to the right the addresses like

    Column A Column B Column C
    Garden avenue Athens 15562

    and the second address to be printed in a separate sheet. I don't care to know how to create a separate sheet, but how to take the value and paste it in there.

    Could anyone help?

    Thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    426

    Re: cell separation

    Use 'Text to Columns' ~ under Data menu in 2010, in the data tools section. Once you start the wizard there are 3 steps. 1) Choose type (select 'Delimited' NEXT 2) For the delimiter, choose comma (by checking the comma box) NEXT 3) Pick the Column Data type(s) [you may want to select 'Text' for all the fields? Especially if the number field has a Leading 0 in it.
    From you example, you will have 6 columns of data...you can then copy the last 3 cells and paste to your other sheet.

  3. #3
    Registered User
    Join Date
    02-15-2019
    Location
    Athens, Greece
    MS-Off Ver
    2013
    Posts
    32
    Quote Originally Posted by queuesef View Post
    Use 'Text to Columns' ~ under Data menu in 2010, in the data tools section. Once you start the wizard there are 3 steps. 1) Choose type (select 'Delimited' NEXT 2) For the delimiter, choose comma (by checking the comma box) NEXT 3) Pick the Column Data type(s) [you may want to select 'Text' for all the fields? Especially if the number field has a Leading 0 in it.
    From you example, you will have 6 columns of data...you can then copy the last 3 cells and paste to your other sheet.
    The problem is that this must be done in VBA because there's more it and all of these elements will be automatically submitted to a database

  4. #4
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    426

    Re: cell separation

    It would be much easier if you upload a 'good' example WITH your expected results....without it it's like trying to solve World Peace. Also, better details. What is 'There's more it and all of the elements..." Perhaps if your data was in a CSV file and you brought it into excel, you could specify the COMMA as the separator and bring into DB.

  5. #5
    Registered User
    Join Date
    02-15-2019
    Location
    Athens, Greece
    MS-Off Ver
    2013
    Posts
    32

    Re: cell separation

    Ok here you go.

    I have highlighted the desired outcome with red. I believe now that it's clear what i want. Thank you for your reply
    Attached Files Attached Files

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,879

    Re: cell separation

    How about this.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  7. #7
    Registered User
    Join Date
    02-15-2019
    Location
    Athens, Greece
    MS-Off Ver
    2013
    Posts
    32

    Re: cell separation

    That's exactly it! Thank you so much for your help!

  8. #8
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,879

    Re: cell separation

    Glad to help and thanks for rep+.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-18-2016, 12:03 PM
  2. [SOLVED] Cell Separation
    By Freshman in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-07-2005, 12:05 AM
  3. [SOLVED] Cell Separation
    By CLR in forum Excel Formulas & Functions
    Replies: 37
    Last Post: 09-06-2005, 10:05 PM
  4. Cell Separation
    By Freshman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 PM
  5. [SOLVED] Cell Separation
    By Freshman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  6. [SOLVED] Cell Separation
    By Freshman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. Cell Separation
    By Freshman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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