Trim content of a column
I agree. Always do a save first. Otto
"Dave Peterson" wrote in message
...
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
|