Posted to microsoft.public.excel.programming

gcotterl[_2_] gcotterl[_2_] is offline

external usenet poster

Posts: 83

Delete rightmost zeroes

How can I delete all of the zeroes to the right of the last 9 in each
row?

For example, here are some rows:

0000000000000000000009990000000
0000000099099000000000000000000
9999000000000000000000000000000
0000000000000000000000000099900
0000000000000099999990000000000
0900000000000000000000000000000
0000000000000000099999000000000

This is result I'm looking for:

000000000000000000000999
0000000099099
9999
00000000000000000000000000999
000000000000009999999
09
0000000000000000099999

Then, how do I find the longest row?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Next-To-Last, Non-Blank, Rightmost Value in a Row	Dave The Favorite	Excel Worksheet Functions	6	November 30th 09 04:41 PM
Formula to delete rightmost N characters	Eric_NY	Excel Discussion (Misc queries)	2	August 14th 09 04:06 PM
Rightmost Column	BillCPA	Excel Discussion (Misc queries)	5	November 14th 07 07:08 PM
how to delete the 4 rightmost digits from a cell	charlene	Excel Worksheet Functions	4	June 29th 06 03:11 PM
Delete cells in row A with just zeroes	Tim Zych[_2_]	Excel Programming	0	July 16th 03 10:31 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us