A
Alex Burman
I know this can be done, but I've forgotten. What is the formula to count
the number of, for example, the letter "d" in a text string in a cell?
Also, I have imported a list of path and file names into Excel. Is there a
formula/function that will allow me to display the file name and remove the
path. e.g.
c:\temp\asg\123\text file.doc to text file.doc
I would like it to be a cell formula rather than using "text to columns".
Many thanks, Alex
the number of, for example, the letter "d" in a text string in a cell?
Also, I have imported a list of path and file names into Excel. Is there a
formula/function that will allow me to display the file name and remove the
path. e.g.
c:\temp\asg\123\text file.doc to text file.doc
I would like it to be a cell formula rather than using "text to columns".
Many thanks, Alex