Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel Text Functions?
I am trying to create a spreadsheet for work that will section out a document path name by specific fields. For example:
C:\Personal\Personal Files\This is a file.doc
I'd like it to be sectioned out by Drive, Master Folder, Subfolders and the Path to the containing folder, so like this:
Drive Master Folder Subfolders Path to containing folder
C:\ Personal Personal Files C:\Personal\Personal Files
I'm having a little trouble with the functions to do this, as the length of each file name and the path name changes. Anyone have an idea how I can get this to section out correctly? I've been working on this for a few hours and the functions are, at this point, not my favorite thing in the world.
1 Answer
- expletive_xomLv 78 years agoFavorite Answer
you want to put everything in its own separate cell....so...you would use "Text to Columns"
if you arent sure how to use it, heres a click by click to test.
- open a new sheet
- copy &paste the 1st 9 items in your column A to this new sheet.....i used your sample (C:\Personal\Personal Files\This is a file.doc) 9 times
- Select A1 to A9
- click Data (menu art the top)
- click Text to Columns (icon near the middle)
- click Delimited
- click Next
- put \ in the box next to Other (Excel should automatically give you a checkmark next to other...if it doesnt, then click a checkmark in yourself)
- click Finish
now you have everything in columns...
column A is C: is your drive
column B is your Master
column C is your sub
column D is your file....or more sub-sub folders
you can copy&paste your new columns anywhere, and label them whatever you want.
usually.....you dont want to do a text-to-columns on your original sheet. so almost always use a separate sheet like this sample, then copy&paste it back to whatever order you want.
if you are going to do this a lot, then record a macro.
let me know how it works.
