I have a sheet that contains a column of xpath expressions (these resemble file paths.) For the most part the first 50 or so characters are always the same. This causes the data to be unhelpful when the column width is made too narrow. Is there a way to get Excel to only show the latter portion of the record when the column is shrunk down.
The actual data looks like this but is quite a bit wider: (and can't change)
/some/path/to/my/stuff/name /some/path/to/my/stuff/address /some/path/to/my/stuff/city /some/path/to/my/stuff/state /some/path/to/my/stuff/zip
When the column is narrow I see this:
/some/path/to /some/path/to /some/path/to /some/path/to /some/path/to
I want to see something like this:
...ff/name ...ff/address ...ff/city ...ff/state ...ff/zip