Can you sort a column by text going right to left?
I am trying to sort a by column, but want the sort to start with the right
side of the column-for example
1234gk-want to sort by kg4321 or really just gk, but I thought I could get
right to left easier.
I don't want to go thru the whole sheet to delete the numbers
If all your data is in that format in an unused column you could enter
Then copy down and sort on this new column
Hope this helps
> I am trying to sort a by column, but want the sort to start with the right
> side of the column-for example
> 1234gk-want to sort by kg...Populating multi-column listbox from collection?
Have a collection containing folders and files that I want to put into a 2
column list box using a For Loop.
I have done this in Access vba and .Net apps, but I'm going crazy trying to
get this to work in excel vba.
Can any one show or point me to a code sample demonstrating this, Please?
Found lots of samples of setting the list() property to an array, but
nothing on doing it row by row with a loop.
Thanks in advance for any help
/ Sean the Mc /
"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)
Was given the a...Adding a string to a text document at the cursor.
I'm using VC++ 6. I've created a small text editor derived from CEditView to
which I've added a drop-down list of phrases off the main menu bar to be
inserted into the text at the cursor when a phrase is clicked. I can't figure
out how to insert the selected phrase into the text I'm editing. I also would
like to know if there is a way to keep the drop-down list open after clicking
on the first phrase, closing it only with 'ESC' or moving to another heading
on the main menu like 'File'. Any leads greatly appreciated.
>I'm using VC++ 6. I've...Can't use Outlook
How can I cancel my account with Outlook? Because I can't
use this software anymore we have installed Lotus Notes
as a source of email and etc. Please notify me and let me
know how to cancel this account. Please I counld go to
far with it because I never knew the server to finish my
OL only has accounts you set up
Tools/Options/Accounts simply delete unwanted accounts.
If you no longer use OL, uninstall. I'm assuming yr refering to OL not
Remember to set yr Internet Options to point to yr new email app
"chuck" <anonymous@dis...2003 Money (Can I -) question
Is it possible to change or preset defaults for the drop
down fields used to create new recurring bill under [Bills
& Deposits]? For example; [Write Check] is the default in
the payment method. I want it to be [Print Check].
[Monthly] is default for the frequency and I want [Only
Once]. I would like to be able to set my most used
selections as defaults.
Thanks - Andy
"Andy" <firstname.lastname@example.org> wrote in message
> Is it possible to change or preset defaults for the drop
> down fields used to create new...Renaming a column label
How do I rename the column header labels from "A", "B", etc. to
something else? Made a valiant effort. Can't figure it out.
DO NOT reply to the "from" address in this post.
Instead, construct a reply address from this
template: v6nos at yahoo dot com.
Short answer: you don't - that capability (other than using numbers
- check the Tools/Options/General R1C1 reference style checkbox)
doesn't exist in XL.
Longer answer: If you hide the row and column headers
(Tools/Options/View) you can format Row 1 for column headers. You
can even use t...Can Publisher create professional books?
I've been told that Publisher can't really format professional
books and to try a Tex variation.
Wondering about opinions on this. I don't want people to be able
to distinguish any difference between a book I publish and
any other book in a bookstore.
Also, what version of Publisher is recomended for this? I am
using one for Win95 and it can't suppress headers on final pages,
which makes for stupid looking end pages. Do later versions have
significant improvements for the book publisher and what are they?
Thanks for your help.
ParaMind B...how can i see my exchange mails from different ISP
i have an exchange server 2003 with windows server 2003 my mails are coming
to my exchange through smtp server on port 25 , my exchange is behind the PIX
firewall my users can check their mails through MSoutlook 2003, OWA and
OUTlook express internaly and can send mails to yaho, hotmail,gmail as well
, so plzz tell me what i have to configure on my server or on pix so that my
users can see their mails from home or different ISP plzz send me the full
configuration because i am new to exchange .
thanks in advance
You have owa already working.
So, let the pix accept con...unique values of a column
how can i get the unique values of a column in an array?
thanks in advance
I think Advanced Filter will do what you want, there is an excellent
tutorial here from Debra Dalgleish
<email@example.com> wrote in message
> how can i get the unique values of a column in an array?
> thanks in advance
Additionally check out Chip Pearson's website at:
>-----Orig..."Group"ing adjacent columns independently
I was hoping that someone might know how to do the following - or
whether it is possible at all ...
I am using Excel's "Group and Outline" capability and I would like to
independently group adjacent columns (or rows). For example, I'd like
to be able to create a group of columns A and B and a separate group
of columns C and D - with each group being independently selectable
via the "+" and "-" buttons. As far as I can tell, if you try to
group adjacent columns, the two groups get merged into a single
group. Also, if I play games by trying to insert an ...Matching Columns in work sheets and copying both rows to new
I am trying to match up two different spread sheets based on one column but
to copy both rows to a new sheet.
eg. First sheet has the following headings:
" "Owner CC
" "Product Categorization Tier 2
" "Product Categorization Tier 3
" "Device Name
" "Model Number
" "Mfg. Name
" "CI ID
" "Old Asset ID
" "Serial Number
" "...looking for a script to make a Distribution List from a text file
Does anyone have a script for making a new Distribution List from a text
file, or CSV file?
I created larger dist lists by using adduser. Then, once the group is
created, I mail enable it.
> Does anyone have a script for making a new Distribution List from a text
> file, or CSV file?
...How do I combine 2 text columns in Microsoft Excel?
I have two columns of descriptive text, the second column is the end of the
first column's sentence, however I can not find a way in the Help options to
combine the text values to create one complete sentence in one column. Does
anyone know of a way to do this?
=A5&" "&B5 if you want spaces between the columns
or look at the CONCATENATE function example =CONCATENATE(A5,B5)
> I have two columns of descriptive text, the second column is the end of the
> first column's sentence, however I can not find a way in the Help options to
...Only one user at a time can access OWA
Using Exchange 5.5 SP3 on W2K. Only one user can log on using OWA at
any one time. As soon as the first user logs out the next can then log
on, but in a organisation of 1300 - bit of a problem.
Previously we did have things working fine with Exchange 5.5 on WinNT
but a hacking attack put paid to that system!
Have run through MS trouble shooting but found no mention of this
problem anywhere else.
Any suggestions welcomed
firstname.lastname@example.org (Mike Cameron) wrote:
>Using Exchange 5.5 SP3 on W2K. Only one user can log on using OWA at
>any one time. As...Publisher 2007 Can i make a calender with holidays already on it?
IS there a way to make a calender in Publisher 2007 that already has holidays
I have a no frills 2009 calendar on my website with the holidays.
http://msauer.mvps.org/publisher_projects2.htm Scroll down a little.
Adding holidays is a manual operation in Publisher.
"Jaci" <Jaci@discussions.microsoft.com> wrote in message
> IS there a way to make a calender in Publisher 2007 that already has holidays
> in it?
...sum values from the same item in a single column?
I have a query to get a table like this:
Item Num Values
A 1 10
A 2 22
A 3 78
B 1 32
B 2 40
B 3 87
C 1 34
C 2 76
C 3 98
actually each "Item" has more than a thousand of "Num".
how to sum all "Item" (A+B+C) at each "Num"?
Have a look at Crosstab queries under Help, that should give you what you...Extracting Data in Cells in order -- (or) eliminating empty cell space in a column
I have this problem that I bet is easy to solve, but i am lost. I am an
expert at the slow way to do things, but maybe there is a better way.
The only way I can describe the problem is by means of an example.
Lets say I have a column of numbers:
>_A_|_B_| etc >>
and then i write a little function in the adjoing cell, B1:
From there I fill down column B to B9.
OK, pretty simple so far, right? What I am looking for is instances
where I find a '3' in co...Query Text in the Mid of a memo
I am trying to query off a memo field [Description] the text that follows
"User Name: " until the first space the "User Name: " is not in the same
position nor is the text of the user name a fixed size.
I am working with an InStr function but I don't know how to stop at the " "
after the name.
Thanks so much for any help.
>I am trying to query off a memo field [Description] the text that follows
>"User Name: " until the first space the "User Name: " is not in the same
>position nor is the text of the user n...text dropped when printing
Sometimes when using several lines of text in a cell
with "wrap text" the last line is dropped when printed,
it shows on the monitor but does not print. Any idea why
this is happening? Thanks.
Are you using a true-type font?
"Carol" <email@example.com> wrote in message
> Sometimes when using several lines of text in a cell
> with "wrap text" the last line is dropped when printed,
> it shows on the monitor but does not print. Any idea why
> this is happening? Thanks.
...Split text cell into seperate colums without splitting up a word
I have text cells with sentences ranging from 0 to 160 characters long. I
want to break these into 40 character chunks (in separate cells), but don't
want to split any word in half. ie, if the 40 char mark is in the middle of
the work, I want to go backwards, find where the word starts and split from
that point. It's exactly like a wrap text -- but I want to split those lines
up into separate cells.
If your sentence were in A1, use these 4 formulas:
=LEF...Relating one column to another
Stupid newbie question coming up:
Let's say that in column A I have a series (not sequential) of numbers. In
column B I have a word that goes with that number.
In column C, I have numbers, which represent the same words as the number in
column a represents the word in column B.
In other words, I have:
Number Word Type:
1: Banana 2
3: Sausage 4
I want to end up with
Number Word Type:
1: Banana Fruit
3: Sausage Meat
4: M...Changing Outlook 2002 email "From" field without the "on behalf of" text
I occassionally want to send emails from an address
different to my standard email account. I'd prefer not to
have to change the email account details on these
occassions. I have the "From" field in my New Mail
template which I populate with a contact showing the email
address I want the email from.
Unfortunately, when the email arrives it appears as
From: [mailto:myEmailAccountAddress] On Behalf Of
I've searched my Outlook settings and the MS site but
cannot see how to get rid of this undesired annotation
i.e. "[mailto:myEmail...re: best way to move columns between 2 excel docs
Ok, here is my little project:
In execel.doc A I have some columns that I want to move to Excel.doc B,
and the columns are always positioned the same way in A, they never change
How do you transfer them to B, to append a running process of pre-existing
prefilled from previous days ?
Any code samples ? Macros ?
Please help!!! :- )
I am reading a book on application-level programming, VBA for Access, so I
understand more and more everyday.
How much work do I have here ?
...Field text range problem
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
In my applescript, I need to find out if the user has put the cursor in a field at the time the script is run. <br>
There is no inField function and I can't seem to get a (start of / end of) text range of a field relative to the start of the document, for each field when looping through all the fields. <br>
I realize that text ranges contain fields. This makes it confusing that I am trying to find a text range or selection object that may be in a field. <br><br>Here is a little scr...Cells in a Word 2007 table do not grow in length; text disappears
In MS Word 2007, I am working with a document that someone else created.
There is a table in the document, and when I add text to the cells in the
table, the cells do not get longer to display the text when the text reaches
the bottom of the cell. Instead, the text and cursor seem to disappear behind
the next cell down in the column (it goes behind the cell that is immediately
below the cell that I'm typing in).
How do I fix this so that the length of the cell will change as text is
added to it? I want the cells to be a fixed width, but get longer if they