+ Reply to Thread
Results 1 to 5 of 5

Pasting information in one cell that goes into multiple cells.

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    ILLINOIS
    MS-Off Ver
    Excel 2010
    Posts
    21

    Pasting information in one cell that goes into multiple cells.

    I was wondering if it was possible for excel to read information posted in one cell and put it into multiple cells.
    My example: I copy and past the temperatures in cell a1... they are in Monday 50 Tuesday 45 format. Cells b1-b7 would consist of the days of the week... b1 monday b2 tuesday and so on. Woud it be possible for excel to read the data... as in it reads monday 50 from cell a1 and puts the 50 in cell c3.. reads the tuesday 45 in cell a1 and pasts the 45 in cell c2. and so on.

    This is just an example.. and im working on something more complex.. but this feature would make things so much easier.
    Is it possible and if so how do I set it up?

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Pasting information in one cell that goes into multiple cells.

    Pl see attached file.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    ILLINOIS
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Pasting information in one cell that goes into multiple cells.

    Basically what I am looking for. But im trying to lets say copy and past the whole week in there. Could you do that?
    Also what if you put in the whole week and lets say... friday is missing. Would everything else except friday past in the correct area.

    Thanks
    -Dawid

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Pasting information in one cell that goes into multiple cells.

    Attach file with input and expected result.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Pasting information in one cell that goes into multiple cells.

    Another:

    =IF(ISNA(VLOOKUP("*" & B1 & "*",$A$1:$A$1,1,FALSE)),"",RIGHT(VLOOKUP("*" & B1 & "*",$A$1:$A$1,1,FALSE),2))
    Last edited by JOHN H. DAVIS; 11-14-2013 at 08:01 AM.

+ 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: 1
    Last Post: 10-17-2013, 10:40 AM
  2. Parsing information in one cell into multiple cells
    By BobbyDylan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-03-2013, 11:40 PM
  3. Breaking up information in one cell into multiple cells
    By NMen in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2013, 12:48 PM
  4. Replies: 2
    Last Post: 04-22-2009, 04:55 PM
  5. Importing information from one cell into multiple cells
    By Goodz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2008, 06:53 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