I always do a save before I play with wildcards--just in case it doesn't do what
I want!

Otto Moehrbach wrote:

Dave
I just have to say, that is neat! Otto
"Dave Peterson" wrote in message
...
How about:

Select the range to fix
edit|replace
what: */
with: (leave blank)
replace all

Are you sure you have a slash and not a backslash?
Maybe you should replace *\ with (leave blank).



BZeyger wrote:

I have a worksheet that contains multiple columns. The first Column has a
file path.
I would like to trim the path to only display the file name.

For example:
A
1 C:/test/folder/File1
2 C:/test/folder/File2
3 C:/test/folder/File3
4 C:/test/folder/File4
5 C:/test/folder/File5

Would like to display:

A
1 File1
2 File2
3 File3
4 File4
5 File5

--

Dave Peterson

--

Dave Peterson