+ Reply to Thread
Results 1 to 3 of 3

How can i split some symbol into many cells ?

  1. #1
    Registered User
    Join Date
    04-16-2006
    Posts
    1

    How can i split some symbol into many cells ?

    For example, cell A1, I have "12/3/2006" I wanna split "/" and then put each value into A2, A3, and A4.

    So, when I write the code A1, B1, C1, and so on. they will split the value and put into each cell.

    A1 = (12/3/2006) ===> A2 = 12, A3 = 2, A4 = 2006
    ....

    How can I do this ?

    Thks
    Kee

  2. #2
    Gary Keramidas
    Guest

    Re: How can i split some symbol into many cells ?

    easiest way

    select column a
    click data on the menu and then text to columns
    click next
    uncheck all boxes except other and then enter the / in the box
    click next
    in the destination box enter B1

    --


    Gary


    "kee149" <kee149.26cbta_1145163001.1668@excelforum-nospam.com> wrote in message
    news:kee149.26cbta_1145163001.1668@excelforum-nospam.com...
    >
    > For example, cell A1, I have "12/3/2006" I wanna split "/" and then put
    > each value into A2, A3, and A4.
    >
    > So, when I write the code A1, B1, C1, and so on. they will split the
    > value and put into each cell.
    >
    > A1 = (12/3/2006) ===> A2 = 12, A3 = 2, A4 = 2006
    > ...
    >
    > How can I do this ?
    >
    > Thks
    > Kee
    >
    >
    > --
    > kee149
    > ------------------------------------------------------------------------
    > kee149's Profile:
    > http://www.excelforum.com/member.php...o&userid=33531
    > View this thread: http://www.excelforum.com/showthread...hreadid=533233
    >




  3. #3
    JMB
    Guest

    RE: How can i split some symbol into many cells ?

    One other way

    A2 = Month(A1)
    A3 = Day(A1)
    A4 = Year(A1)

    Copy across

    "kee149" wrote:

    >
    > For example, cell A1, I have "12/3/2006" I wanna split "/" and then put
    > each value into A2, A3, and A4.
    >
    > So, when I write the code A1, B1, C1, and so on. they will split the
    > value and put into each cell.
    >
    > A1 = (12/3/2006) ===> A2 = 12, A3 = 2, A4 = 2006
    > ....
    >
    > How can I do this ?
    >
    > Thks
    > Kee
    >
    >
    > --
    > kee149
    > ------------------------------------------------------------------------
    > kee149's Profile: http://www.excelforum.com/member.php...o&userid=33531
    > View this thread: http://www.excelforum.com/showthread...hreadid=533233
    >
    >


+ 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