[project1dev] Re: [Offtopic] Excel Question
- From: Nick Klotz <roracsenshi@xxxxxxxxx>
- To: project1dev@xxxxxxxxxxxxx
- Date: Wed, 12 May 2010 18:52:26 -0400
it creates a copy of A to column D
in E it will call the RIGHT function to create a column of the GB, MB,
and KB fields
in B I do a seperation three times using G, M, and K as tags, so it
deletes K, M, G from column A and creates column B with the trailing "B"
in column C I do a "If column E=GB, columnA*1000, if E=KB, columnA/1000,
if E=MB, columnA
then once column C is filled out all the way, it does a copy/paste values
to Column A, then deletes all the other info
A
SIZE txt to col right(A,2) 3.4GB 3.4GB B GB 45.0MB 45.0MB B MB 614.7KB
614.7KB B KB running right(A,2) will copy the two most right characters in
that column running text to columns 3 times using G, M, then K as filters
will produce the following
if(E=GB,A*1000,if(E=KB,A/1000),A) 3.4 3400 B 3400 GB 45 45 B 45 MB 614.7
0.6147 B 0.6147 KB After all that, data from column B is copied to column A,
all other data cells are then deleted Final Output Size In MB 3400 45 0.614
On Wed, May 12, 2010 at 6:33 PM, Alan Wolfe <alan.wolfe@xxxxxxxxx> wrote:
> maybe.. what are you trying to do?
>
>
> On Wed, May 12, 2010 at 3:22 PM, Nick Klotz <roracsenshi@xxxxxxxxx> wrote:
>
>> Is anyone here very advanced, or a master with Excel 2007 or 2010? I have
>> a question on how to do something, and I have a process but it's complicated
>> and way more involved than I think it needs to be.
>
>
>
Other related posts:
