I have four columns to combine and I use the concatenate function. One of my
columns has either 3,4 or 5 characters. When I concatenate, there are spaces
in the middle of the end product.
How do I get those spaces to disappear in column 1? I can't just set the
length of the column to 3 or 4 or 5 characters because I need that varied
length. I just don't want the spaces at the end.
A1: "Alpha "
B1: "Bravo "
C1: "Charlie "
(all without the quotes, of course)
This formula scrubs the spaces from the end result:
D1: =SUBSTITUTE(A1&B1&C1,...Axis Issues
I am having a problem that I think has a simple fix, but I can't figure
I have created a simple bar graph where one bar has a negative dollar
value and the rest have positive vales.
The problem is that I can't figure out how to leave the x axis at $0.00
value where it intersects the Y axis and have the column labels show at
the bottom of the chart.
If that makes no sense please see attached picture!!
If anyone can help I would be much appreciated!!
|Filename: cHARTTTTTTT.JPG ...Problems installing 12.0.1 update
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
I am also having problems, I have recently installed Leopard but this is probably not the problem. When installer searches for available disk storage I receive this message: "You cannot install Microsoft Office 2008 for Mac 12.0.1 Update on this volume. A version of the software required to install this update was not found on this volume." I have 2008 installed and can run it, so not sure what installer is looking for. Could I have deleted a file accidentally? What should I look for and where?
&...Re: Exporting meeting responses #2
Attendees Print is small utility specially designed for Microsoft Outlook
users to print the names of the people who have been invited to a meeting
and response status - Accepted, Declined, Tentative, None. Obtain
information for Meting Request items from any Outlook Appointment folder.
You can print directly the names of the people who have been invited to a
meeting and response status - Accepted, Declined, Tentative, or None. You
can save/export report as RTF, PDF, Word, ...What are the features of 1.2?
We have recently begun using MSCRM and are very unhappy. What are the
updates that will be in 1.2?
1. Is synch speed addressed?
2. Can you customize activities?
3. Any improvements to usability for sales people?
1) From what I've heard, the synch speed has increased quite a bit.
2) No. This is to be in the v2.0 release in Q404
3) In what way? They didn't change that much in terms of "features" for
"Chuck Latham" <firstname.lastname@example.org> wrote in message
We have recently begun us...Smart Lists
We find it would be helpful if there were a different icon for each report
based on the visibility (System, Company, User ID, User Class). I might also
be helpful to see who created the report, maybe by right clicking the icon.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agr...Global Address List / Address Lists in Exchange 2003
Hi. I've recently installed Small Business Server 2003 and have been testing
clients with Outlook 2003 connecting to Exchange 2003. What I would like to
do is have an address book stored on the server with all of the company's
contacts, that anyone internally can add to and edit. I know that the GAL is
already populated with all of the company employees who have mailboxes (from
the Active Directory) but the GAL seems like it can only be viewed in the
style of clicking "To" on a new email. What we would like to do is have ALL
company contacts (both internal and external) in on...Registry
OK Guys & Gals, you are sooo helpful. Rather than search help/net for
how-to-do, I'm sure one of you can give me the answer.....
I want to launch a web-browser from my app. How do I find out which
web-browser the user has installed/is using. I suppose, similar question is
how to do same if I want the user to contact me via e-mail. Here's a code
fragment of what I currently do (red-faced, a little. But I'm not too proud
to ask for help & yes, I no WinExec is old-hat but so am I).
CString csPath = "SOFTWARE\\Microsoft\\Windows...Putting Products in a Pick List Custom Field
Is it possible to add a Picklist ( drop down box ) to a custom form, which
has a list of products?
Sorry, I don't mean Picklist I mean select box with the magnifying glass
next to it so you can choose the products..
"Luke Baines" <email@example.com> wrote in message
> Is it possible to add a Picklist ( drop down box ) to a custom form, which
> has a list of products?
...no smart tags
i downloaded a trial version of excel 2007...I want to update my excel stock
portfolio with current stock prices...BUT THERE ARE NO SMART TAGS in my
spread sheet...I tried to intall the smart tag install.exe file but it does
not exist...trust me..
any suggestions...(no recognizers in smart tag)
...Outlook Distribution Lists
I can find twenty answers to my '?'-I want to find the 'best practice' answer.
Info- I work on team that is consultant with a company. Each member of team
has multiple email address. depending on intention of email, it may have to
be mailed to one or several of the each person's email addresses. We
constantly sending to wrong address, miss or sending to too many addresses
for each person.
I'm looking for best and why
- easiest and best way for me to send to them and them to save
since possibility of at least 5 distr lists of the group but differen...Searching in a list box
Hi guys ...
Here is an interesting one for you
I have a list box on the screen with circa 300 from which
to choose from. All these are unique and the screen is set
up with many 'fields' which change data according to the
option selected in the list box. Basically these are all
linked with a vlookup formula.
This all works fine. Now what i would like is to have an
additional "Search field" were i can input a word and a
search occurs in the list box i,e, in these unique fields
and excel highlights in the list box the one which
contains a similar word. If the word is...Acess DB - list of worldwide contacts
I have created an Access DB showing a list of over 150 contacts worldwide.
What would be ideal, to show them to the boss, would be to plot the cities
against a map and reference them with a numbered flag relating to the
corresponding record. Can this be done? Please Help.
Google has a mapping api that may be able to help:
Arvin Meyer, MCP, MVP
"YorksTopBear" <YorksTopBear@discussions.microsoft.com> wrote in message
news:6842DCA5-3E0E-4F70...Unable to deliver the message due to a communications failure #2
The following recipient(s) could not be reached:
Unable to deliver the message due to a
The MTS-ID of the original message is:
c=US;a= ;p=UCP Queens;l=UCPQ1-031104184842Z-2282
0x80004005 (000502FE) Conversion to Internet format failed
...change csv list separator in excel 2007 Dutch version
I have Windows XP english version and office 2007 Dutch version.
When creating a csv file from excel 2007 file a semi colon (;) is used as
list separator instead of a comma (,).
I already tried to change the list separator to a comma via Control
Panel>Regional and Language options>Customize
This does not work.
When I change my current format to English (Control Panel>Regional and
Language options) the list separator in the csv file changes to a comma.
Is there a workaround so that I don't have to change the format every time?
Won't you have...Disappearing emails #2
I'm running Windows XP with SP1 and IE 6 with SP1 and using Outlook Express 6. When I download my emails to my inbox they disappear if I click on a different box and then click back onto my inbox. I've gone into options and unchecked the "Do not allow Attachments to be saved or opened that could potentially be a virus." I've checked for updates and I should be OK. What do you think might be the problem
Thanks for your Help!
I am upgrading the Spanish translated version of eEnterprise 7.0 to GP 9.0
with the Chile localization. The existing 7.0 installation has two products
in the Dynamics.set: Factura Electronica (FACELECT.dic) and Nota de Credito
Electronica (NCELEC.dic). The product numbers are 15003 and 15010. Are
there corrsponding 9.0 products that need to be installed?
Thanks for your question.
Products 15003 and 15010 are not owned by Microsoft. I believe these are
part of a partner release and that the name of the partner is cMetrix. Any
upgrade questions will need to be asked of them....Word doc. list to excell worksheet, how to?
Its great to be able to use a chart/worksheet made in excel and transfer it
to a word doc. but what I really need now is a solution to how to transfer a
word doc. list into a brand new worksheet.
You may be able to save it as a text file and then import into Excel. It's
not clear what you have in your word doc however.
> Its great to be able to use a chart/worksheet made in excel and transfer it
> to a word doc. but what I really need now is a solution to how to transfer a
> word doc. list into a brand new work...Drop Down List More
I have a drop down list, I want it to select the choice when the first letter
is typed in. How can I do that?
I just need the dropdown to ensure there are no typos in the answer.
One way is to sort your validation list and at the beginning of the A's enter
a single A, do the same for the beginning of the B's and all the way through
to the Z's.
Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.
...how to scroll to a position in a multiselect list box ?
I have an estimating form (continuous form subform) that occupies all of the
I am working on creating a fairly friendly mechanism to allow the user to
pop up a multi select box and choose multiple line items to group them
(they right mouse click in the sequence field in the large form, choose a
menu item 'Group into Visits') and it takes them in to a new form with the
list box showing the record they just selected as highlighted. They can then
multiselect additional records.
By necessity the listbox is much shorter than the main estimatin...Nested If Functions #2
I am having trouble using a nested IF function to determine my UC wage
that I show in the table below.
1st & 2nd quarters 3rd quarter excess
$17000 $8000 n
I would like to write the function as follows:
If the 1st and 2nd quarters are less than $8500 then the UC tax is du
on the excess of first and second quarters up to $8500 (say $4000 wer
the wages in the...mailbox size limits #2
We currently do not have any size limits and have a few users with huge
I want to know if I setup the mailbox sixe limit's does exchange have a
ceiling on it.. I tried to set the limit for like 4 gig but it wouldn't let
Please let me know.
Well via the GUI its 2 GB.
But you can do this to go higher:
"Stup88" <Stup88@discussions.microsoft.com> wrote in message
> We currently do not have any size limits and have a ...Keeping Office 2004 Apps the Default After Installing 2008
After installing 2008 all my documents are opening by default with the 2008 versions. I'd like to switch this so I have time to adjust and because some programs like Endnote aren't yet compatible with 2008. I'm hoping I don't have to uninstall 2008 until I ready to fully commit.
On 2/17/08 1:50 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> After installing 2008 all my documents are opening by default with the 2008
> versions. I'd like to switch this so I have time ...Inverting Text #2
I have a simple question with Microsoft Excel 2000, if
anyone could e-mail me the answer to:
it would be much appreciated.
How do you invert text (turn in upside down)? I'm trying
to print something but have it come out upside down, and
help would be much appreciated.
Thanks a bunch,
If its not possible, let me know as well.
If its easier, just respond here, instead of sending an e-
Thank you very much in advance,
You can use the camera tool and insert a picture, then rotate the picture.
It's under vie...Custom Smart List Not Showing up in Smart List
I created a custom smart list, linking a custom sql table to the employee
master table from Payroll.
I call the Smart List Employee Allociations, but it does not see in Smart
List screen when I bring it up.
I am linking both tables on the employee id field.
Any help would be appreciated.
Check this link
Also look out in web for "Explorer Application Programming Interface"
> I created a ...