+ Reply to Thread
Results 1 to 3 of 3

Need Help in Excel formula having paths in sheet

  1. #1
    Registered User
    Join Date
    03-17-2024
    Location
    Earth
    MS-Off Ver
    latest
    Posts
    1

    Need Help in Excel formula having paths in sheet

    Hi All,

    There are 2 columns in the Excel column A have name of network paths separated ";", in column B i also have network paths but its multiple separated by ";",

    example 1
    in A1 i have "\\fileserver\SharedDocs; \\company\marketing; \\home\engineering"
    in B1 i have "D:\Games\Pokemon; E:\Music\Pokemon_Symphonic; C:\Program Files\Pokemon_GO"

    so i want to take A1 value as a reference and i want in C1 "\\fileserver\SharedDocs; D:\Games\Pokemon, \\company\marketing; E:\Music\Pokemon_Symphonic, \\home\engineering; C:\Program Files\Pokemon_GO"

    please give me Excel formula

    Thanks

    Excel sheet also i have attachedsample excell.xlsx

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Need Help in Excel formula having paths in sheet

    This seems to work with 365:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You will need to remove any trailing semi-colons.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: Need Help in Excel formula having paths in sheet

    No restrictions:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. HELP with renaming file paths in excel
    By noob2214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2022, 08:53 AM
  2. Looking to incorporate multiple file paths into a lookup formula
    By BaronVonTeabag in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2020, 10:42 AM
  3. Replies: 3
    Last Post: 04-04-2020, 06:02 PM
  4. Commas and Ampersands in formula paths
    By Steve2107 in forum Excel General
    Replies: 1
    Last Post: 12-14-2016, 01:27 AM
  5. Commas and Ampersands in formula paths
    By Steve2107 in forum Excel General
    Replies: 1
    Last Post: 12-14-2016, 01:22 AM
  6. update problem puts file paths into formula
    By FRIEL in forum Excel General
    Replies: 1
    Last Post: 03-23-2009, 07:39 AM
  7. [SOLVED] excel file paths
    By Jane in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 12:05 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