+ Reply to Thread
Results 1 to 3 of 3

Looking for Nested If Statement to move content of cells to new cell

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    5

    Looking for Nested If Statement to move content of cells to new cell

    Hi all,

    I have a common problem a 500-1000 row report. The report comes to me as an Excel file with most of the important information in the "comment" field. I would like a solution to move the document file name into the cell to the right. The document file name always starts with "\\adm"

    This field contains random notes, links to documents on our server.

    I'd like to see how to create a nested if statement or other technique to use inside a macro.

    I have attached a mock spreadsheet showing "How it is Now" and "How I want it to Be".

    Thanks in advance for your comments,

    Adam
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Looking for Nested If Statement to move content of cells to new cell

    Not sure If I understand your question, but maybe this in B, copied down?

    =IF(LEFT(A3,2)="\\",A3,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Looking for Nested If Statement to move content of cells to new cell

    Here's a relatively easy, non-VBA way to do that...

    Use [Find & Select's] Replace...
    Find What: \\adm
    Replace with: ¶\\adm

    I chose to use the ¶ character because it is likely unique to all data characters. It can be any such unique character.

    Assuming column A is the only content, click Replace All and Close

    Select A2, then Ctrl+Shift+[down arrow].

    Now do Text to Columns > Delimited > Delimters: Other: [¶] > Finish.


    READ BEFORE DOING - If you record a macro while doing the above, you should get one to repeat the process automatically.

+ 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] How to automatically move Line(Shapes) based on cells content?
    By hmgrts in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-12-2013, 01:30 AM
  2. Need to move cell content with scroll
    By msub in forum Excel General
    Replies: 0
    Last Post: 01-12-2012, 07:09 PM
  3. move cells based on partial-content.
    By jimmyyang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2008, 02:21 AM
  4. Replies: 2
    Last Post: 12-19-2006, 10:50 PM
  5. [SOLVED] move part of a cell content
    By slowhand in forum Excel General
    Replies: 2
    Last Post: 04-14-2006, 11:20 AM

Tags for this Thread

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