Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: If cell contains text then copy/paste text from a different cell

  1. #1
    Join Date
    14th December 2010
    Posts
    7

    If cell contains text then copy/paste text from a different cell

    I am trying to build a formula that would say If cell contains text then copy/paste text from a different cell.

    For example:

    I am writing my formula in cell I5. If there is any text in J5 then I want the text from J3 to appear in I5.

    Background:

    -What I am doing is making an excel spread sheet for meeting notes.
    -Column A has the project names.
    -Column I is the date the project was last updated.
    -Columns from J on, represent weeks. (Column J is for 1/1, Column K would be for 1/8, Column L would be for 1/15, etc.) The column heading (the cells in row 3) would be the date.

    Each week, a new column is added (for a new week) and if there is any new information it is typed for that project for that week. If there is any new text in that week's column, I want the heading for the column (in my case the date for that week) to appear in Column I.

    I hope this makes sense; please let me know if I need to clarify anything.

    Thank you,

    Laura

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd October 2003
    Location
    France Alsace
    Posts
    3,671

    Re: If cell contains text then copy/paste text from a different cell

    If there is any text in J5 then I want the text from J3 to appear in I5.
    And if there is numbers?
    Is it not just to check if the cell is empty?
    Why not
    =IF(J5="",J3,J5)
    Triumph without peril brings no glory: Just try

  3. #3
    Join Date
    14th December 2010
    Posts
    7

    Re: If cell contains text then copy/paste text from a different cell

    That sort of does what I am looking for; however, I am not checking to see if the cell is empty, but rather checking to see if it has text.

    In the example formula you provided, it pulls the text from J3 to I5, even though J5 was empty. I only want it pull the text from J3 if there is text in J5. If J5 is empty, I want I5 to remain empty. Does that make sense? Sorry I didn't make myself more clear. I tried tinkering with the formula you provided but I still couldn't get it to work the way I wanted.

    Thank you for your help.

    Laura

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    3rd August 2010
    Location
    Union City, Pa - USA
    Posts
    607

    Re: If cell contains text then copy/paste text from a different cell

    What about this. if A1 is empty then A1 stays the same but if a1 has text then b1 = c1
    =IF(ISBLANK(A1),A1,C1)

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    3rd August 2010
    Location
    Union City, Pa - USA
    Posts
    607

    Re: If cell contains text then copy/paste text from a different cell

    =IF(ISBLANK(J5),H5,J3) this is specific to your needs

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    23rd October 2003
    Location
    France Alsace
    Posts
    3,671

    Re: If cell contains text then copy/paste text from a different cell

    Perhaps change I5 formula to
    =IF(J5="",J3,"")
    Triumph without peril brings no glory: Just try

  7. #7
    Join Date
    14th December 2010
    Posts
    7

    Re: If cell contains text then copy/paste text from a different cell

    Quote Originally Posted by yegarboy View Post
    =IF(ISBLANK(J5),H5,J3) this is specific to your needs
    Awesome; that does it! I was trying to use the "isblank" and "istext" functions, but I wasn't getting the last half of it correct. I will have to study this to figure out how it works, but that is what I was looking for!

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    3rd August 2010
    Location
    Union City, Pa - USA
    Posts
    607

    Re: If cell contains text then copy/paste text from a different cell

    Glad to help

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 16
    Last Post: November 15th, 2010, 08:14
  2. Copy & Paste Specific Text From Cell
    By Excel Noob in forum EXCEL HELP
    Replies: 8
    Last Post: September 13th, 2010, 20:25
  3. Replies: 2
    Last Post: May 9th, 2008, 02:14
  4. Paste Multi-lined Text Into Cell
    By SalicBlu3 in forum Excel and/or Word Help
    Replies: 2
    Last Post: February 26th, 2008, 13:11
  5. Paste text into just one Cell
    By musicmike in forum EXCEL HELP
    Replies: 4
    Last Post: October 6th, 2005, 11:26

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
  •  
porno