In column B I have a list of names generated by an IF function. The IF function gets the information from a different sheet which gets its info from a file containing a list of file names in a folder including sub-direcotries. So the column the IF is pulling the info from also contains other info I'm getting in different columns (hence the IF function).
Here's my problem. In B, I have the folder the files in column A are in. but I don't want the entire address of the folder, I just want the folder name, so I want to delete the frist 38 characters of all cells in B. I want this to happen automatically. I don't want to have to run a "CTRL+H" macro(currently my best option), and the Data->text to column doesn't seem to work because B contains only formulas, not actualy text.
any help would be appreciated.
-jed
Here's my problem. In B, I have the folder the files in column A are in. but I don't want the entire address of the folder, I just want the folder name, so I want to delete the frist 38 characters of all cells in B. I want this to happen automatically. I don't want to have to run a "CTRL+H" macro(currently my best option), and the Data->text to column doesn't seem to work because B contains only formulas, not actualy text.
any help would be appreciated.
-jed