LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 83
Default Finding right-most cell.

On Sep 27, 1:17*pm, Ron Rosenfeld wrote:
On Mon, 26 Sep 2011 18:38:19 -0700 (PDT), gcotterl wrote:
Posted: Tue Sep 27, 2011 1:04 am * *Post subject: Find right-most
byte


--------------------------------------------------------------------------*------


My text file has 1 million rows each 1,274 characters long.


How can I find the row having the number 9 in the right-most cell?


For example, how do I find the row indicated with an arrow?


0000000000000000000009999900000
0000000099999000000000000000000
9999000000000000000000000000000
0000000000000000000000000999900 *<----------------------
0000000000000099999990000000000
0000000000000000000000000000000
0000000000000000099999900000000


What do you mean by a "row each 1,274 characters long"?

Do you mean that each row has 1,274 cells, each with a single character?

Or do you mean that only one cell in each row is of concern, and each of those cells has 1,274 characters?

Or do you mean something else?- Hide quoted text -

- Show quoted text -


Each row has one and that cell has 1,274 characters.

My question simplified: How can I delete the zeroes after the last 9
in each row?


 
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
finding last non-blank cell and then copying it to the next cell mike_vr Excel Discussion (Misc queries) 0 January 17th 08 05:02 PM
Finding last cell Jim[_2_] Excel Worksheet Functions 15 February 17th 07 07:45 PM
Finding Cell Interior Colour of First Cell in Column ExcelMonkey[_190_] Excel Programming 4 March 22nd 05 03:01 AM
finding a cell rbekka33[_18_] Excel Programming 0 September 23rd 04 10:25 AM
Finding a cell Alan Excel Programming 5 July 22nd 03 06:25 PM


All times are GMT +1. The time now is 05:35 PM.

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"