+ Reply to Thread
Results 1 to 4 of 4

Copy cells based of certain text or blanks spaces?

  1. #1
    Registered User
    Join Date
    07-09-2020
    Location
    Ohio, USA
    MS-Off Ver
    365
    Posts
    2

    Copy cells based of certain text or blanks spaces?

    Im looking for help with combining formulas in the right order to reach my goal. But im uncertain of how to combine IF, SEARCH, or others together for my goal. Thanks for the help.

    Please see below.
    Goal - Copy F4 to D4 and F5 to E5 (typical for a table containing 150 rows)
    All F4 types cells are different because they have 6 blank spaces before the text, and outline numbers are x.x (2 digits)
    All F5 types cells are different because they have 9 blank spaces before the text, and outline numbers are x.x.x (3 digits)
    Its pretty straight forward how to copy F3 to C3, but Thought I would point out that is part of what I am doing to. F3 has zero spaces.

    F3 - "Planning" - zero spaces
    F4 - " PIR Adoption" - six spaces
    F5 - " Submit PIR to FCR" - nine spaces
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Jonathanbarrick; 07-09-2020 at 02:19 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,931

    Re: Copy cells based of certain text or blanks spaces?

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

  3. #3
    Registered User
    Join Date
    07-09-2020
    Location
    Ohio, USA
    MS-Off Ver
    365
    Posts
    2

    Re: Copy cells based of certain text or blanks spaces?

    Oh thank you for the reminders. I attached the sample excel file showing exactly what I was trying to do to the original post.

  4. #4
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    713

    Re: Copy cells based of certain text or blanks spaces?

    I have several questions, like will the length of the outline number determine what cell the value form col F goes into?
    You mention that "All F4 types cells are different because they have 6 blank spaces before the text, and outline numbers are x.x (2 digits)"
    So there's an AND condition, but do you really mean that? If so, what's the result if the AND condition isn't met (meaning, what if F4 has 0 spaces but the outline number is 3 digits (or 5 characters).

    My solution assumes that the Outline number determines what column the value goes in. It's based on the CHARACTERS in the outline number (not the digits) another assumption. Anyway, in your example, in cell C12 I put this formula, and you can copy it over and down:

    =IF(LEN($B12)=2*COLUMN()-5,TRIM($F12),"")
    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. [SOLVED] Copy non-adjacent cells, paste without blanks (based on only one column)
    By LukeNZ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2018, 11:13 AM
  2. Rearranging text based on spaces and comma
    By xo1darcie1ox in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-30-2017, 02:26 PM
  3. [SOLVED] Copy cells to another column without spaces
    By hau_rude in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2016, 08:45 AM
  4. Copy lines of text cells, to another area, based on color of text.
    By richard11153 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-10-2016, 03:53 PM
  5. Getting Rid of spaces in Text within Cells
    By eguirocker3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2014, 12:56 PM
  6. Replace blanks/spaces
    By antony moseley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2009, 12:48 PM
  7. Replies: 6
    Last Post: 03-23-2005, 07:06 PM

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