I have a text string, let's say it is "test this, string". I can find the position of the comma (position 10) and need to know at what position the space appears BEFORE the comma (this would be position 5). Can I use a reverse string or -FIND to start at the comma (position 10) and pull back position 5? I need to do without VBA.
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…