LinkBack URL
About LinkBacks
The simple Data TextToColumns functionality seems to provide all you need.
Just copy the file into column A in a worksheet and specify the comma as a delimiter.
The simple Data TextToColumns functionality seems to provide all you need.
Just copy the file into column A in a worksheet and specify the comma as a delimiter.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I just tried to use the function, but I couldn't quite figure out how to do it with the variable of the different files that will be added. See most of it needs to be variables that just read in the title (which could change from file to file). The delimiter being "," was a good help though. Just can't figure out what looping style I need to use nor how to use it to extract the substring. Thank you though!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks