Re state your desired outcome. There is confusion about the / within the
<li

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Easton King" wrote in message
ps.com...
On Sep 17, 8:58 am, "Don Guillett" wrote:
A reiteration of what I did (Vista HP, xl2003 up to date)

I copied the list below into col I
I copied the LAST item which was <li and got no deletion using "<li"
I copied the next to last item and removed the preceding text to get
"</li"
Somehow, excel changed to ""< li ""
But NOW, I can't replicate.???? Hopefully the OP will tell us the desired
deletion
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Easton King" wrote in
message

oups.com...

I have a large xls doc and some cells have entries that end with
<li. I want to remove only this last instance of <li and only when
it is the last thing in the particular cell.
For example:
<li
Blah blah blah</li
<li
Blah blah blah</li
<li
Blah blah blah</li
<li

In this case, I want to remove only the last instance of the <li

I have ASAP utils also, but can't seem to figure the logic to make
this happen.

TIA for any help you may be able to provide.

The intended output for this issue would be:

<li
Blah blah blah</li
Don
<li
Blah blah blah</li
Sandy
<li
Blah blah blah</li

-----
Sorry, but you guys have kinda lost me already on this one. Not sure
what to make of all of the above...