On Thu, 27 Apr 2006 13:25:01 -0700, nastech
wrote:

Hi, sorry, can be difficult to explain, kept getting formula's - needed
format.. but had to repost 4-6 times... losing track:

downloading data to column where I mostly need it (midst other down loaded
data, by copy-paste at this point: thats the rub/why)

don't have use for separate work column for that. other columns that work
off that data, e.g.: 1.5B some 1.511B in length, 1.5M.... have equations
that work fine using concept of: Left(LEN)-1 etc.

column data in very hard to read / too wide. (as above:
120.511B
1.0M
1.2B ...


Let me ask some questions which can be answered simply, in order to try to
clarify the situation.

1. Does every entry end with a letter?
2. Are the letters always "B" or "M"?

3. If there are other letters that an entry might end with, what are they and
what do they stand for?


--ron