LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Remove last <li entry from cells

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Entry That Locks Selected Cells From Any Data Entry. ron Excel Worksheet Functions 5 February 16th 07 09:52 PM
remove entry from namebox WaterNinja Excel Discussion (Misc queries) 1 November 2nd 06 11:26 AM
Remove Spaces beginning Time entry Damon Longworth Excel Discussion (Misc queries) 10 June 19th 05 04:37 PM
Force entry to one of three cells Martin Smith Excel Worksheet Functions 2 May 27th 05 09:52 AM
How to you count cells that contain any entry? Robin C Excel Discussion (Misc queries) 3 January 16th 05 02:25 AM


All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"