How do I preserve text color when combining cell data
I'm using "&" to combine data from multiple cells. Each cell has text of a
different color and I want to preserve those colors in the new combined cell.
The new combined cell is formatting all the text to one color.
Anyone have any suggestions on how to maintain the separate colors in the
A formula can only return a value to a cell, so you cannot return formatting
=A1&A2 will return the value of A1 and A2 to the cell that has that formula
entered in it.
"CraigS" <CraigS@discussions.microsof...Matching function or no match
I am using this formula to compare 2 list to see which numbers are not
included in both column A and Col C. The formula I am using below pulls out
the ones that i do have a match . Is there another function that I could
use that would only pull out the ones that there is not a match?
"Donna" <email@example.com> wrote in message
> I am using this for...Client E-Mail and Web E-Mail not matching
I've got a few complaints from about 4 users where e-mail they see in their
Outlook Client is not showing up in their Outlook Web Client when they check
their e-mail from a remote location.
We're using Exchange 2003 with SP2 installed and all the users have Office
Outlook 2003 with SP1 Installed also.
This seems to only have been a problem since we upgraded to Exchange SP2 two
weeks ago. (Although I can't confirm it, but I wasn't told of any problems
before th upgrade.)
We had to upgrade to SP2 because of the 16 Gig limit so rollback is not an
Best as I can t...Extracting Data from Excel
Is it possible to use excel like a CRM software?
Currently i am using excel to store my customer list, requests and
I would like to extract data from those information such as by company,
location, and status.
What would be the best way to implement this? Is there any guide to do this?
Thanks in advance
How about use of Autofilter & Advanced Filter?
MVP Debra Dalgleish has some nice illustrations at:
Check out the relevant links on her home page
Please reply in n...column charts on two axis
I am trying to show a column chart on 2 axis. I have chosen the combination
line and column chart to get the 2 axis but when I change the line to a
second column it puts the columns over the top of the first axis columns. How
do I get them to be side by side?
Have a look at: http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
Bernard V Liengme
remove caps from email
"Jo" <Jo@discussions.microsoft.com> wrote in message
>I am trying to show a column chart on 2 axi...Matching cells #3
Here's my spreadsheet:
A B C
1 1 1
2 3 3
3 4 6
4 5 10
5 8 11
How do I get the matching numbers on the same rows, like:
A B C
1 1 1
3 3 3
10 10 10
I would just re-create the columns.
1. Copy column A into D.
2. In E1 put:
3. Copy it over to F1 and then down as far as needed.
4. Select columns D thru F, copy them, and go to Edit >
Paste Special > Value. Press OK.
5. Delete column A thru C.
&g...MDI app with different CFrameWnd, searching one
in my MDI application, I use several different CChildFrame windows with its
CDocument and CView.
CPersonFrame* mit CPersonDoc und CPersonView
CAdressesFrame* mit CAdressesDoc und CAdressesView
CPreferencesFrame* mit CPreferencesDoc und CPreferencesView
The PreferencesFrame and AdressesFrame should be opened only once at a time
in my programme. The PersonFrame is a single window concerning each person
in the AdressesFrame.
Now I want to open a special window in my application menu. If it's already
opened, it should appear in front. So I first look for the child window if
it is...deduplicate data in excel
How do I deduplicate data in Excel. I have a large database of names and
addresses which I want to check to duplication
You may want to read some of Chip Pearson's techniques for dealing with
Julie Melbourne wrote:
> How do I deduplicate data in Excel. I have a large database of names and
> addresses which I want to check to duplication
I have looked at this site, but cannot get the formula to work?
Must be doing something wrong. Have you tried it?
Do you have a working spreadsheet wtih...Move data to right with variable rows
I have a large spreadsheet with corrupted data. I can identify several types
of bad data and have correct the data in these rows but one particluar type
is giving me problems.
Because the spreadsheet is large I used filtering and visible cell commands
to correct blocks of data. This seems to work fine but one type is still not
working so I am trying a row by row logic search. In this case the bad data
needs to move from cell column B to C with the range through L. So any data
in the range B through L in the selected row is copied if the contents of L
="N". A cel...Word versions differences
What are the main differences between Word versions 2000, 2002, and 2003?
I'm looking for any kind of info, but a chart would be great!
You might look at "Description of new features in Word 2002" at
http://support.microsoft.com/kb/288725 and at "What's New in Office 2003?"
and similar articles. You can also look at "What's new?" in the Help file
for each application.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http:/...Lookup Formula: Return 1st match, then 2nd match, then 3rd match
I have a spreadsheet that looks like the following. Tab 1. Col A=Name. Col B
Bob Reconcile Cash
Tim Do Sales Report
Bob Create presentation
Tim Prepare financial statements
Bob Hire staff person
Now on tab two, I want to create another list that pulls all the tasks
together by person. For example, Tab 2 would look like this:
Bob Reconcile Cash
Bob Create presentation
Bob Hire staff person
Tim Do Sales Report
Tim Prepare financial statement.
I realize I can just sor...Can I have each series be a different field in a Pivot Chart?
I'd like to create a stacked column chart using a Pivot Chart. But each of
the series that I'd like to stack are in different field (columns) in my
source data. Is it possible to do this? I can't rearrange the source data,
because then I'll exceed Excel's 64K row limitation.
I am quite sure you can do it, but need more info about your set up before I
will be aboe to give any recommendations
Where is the data for each series?
> I'd like to create a stacked column chart using a Pivot Chart. But each of
> the series that I'd...Cannot edit an imported Access table
I just imported data from an excel table into an access 2002 database. I
cannot, however, edit the table (ie. delete a record, add a primary key,
Did you 'link' the data or import it from an Excelfile. What steps did you
"Carl Gross" wrote:
> I just imported data from an excel table into an access 2002 database. I
> cannot, however, edit the table (ie. delete a record, add a primary key,
I imported it. I tried importing direct from a Paradox table. I also tried
exporting the Paradox ta...Many to Many Data Integrity (Alway confuse myself)
OK, thanks in advance. I always screw this up so here it goes:
Three tables: Line, Part, LinetoPart
I could set these tables up differently, but Part A can be ran on
Line1, 2, or 3.
LinetoParts has autonumber pkLinetoPart, fkLine, and fkPart.
So how do I keep the many table from duplicating say an entry stating
that Part A to Line 1? Am I missing the boat here?
In the LinetoParts pkParts can duplicate and pkLine can duplicate, but
I don't want a duplicate record with the same pkPart and pkLine.
*Relationship Algebra why do you plague me so?*
At the nuts and bolts level, wh...Multiple Record(12 Entries) Into Table w/ Form
I am attempting to send more than one record with one form to the table and I
can't seem to get INSERT ... VALUES to enter records separately and the text
boxes have different names but the same Control Source so when i change the
number all the fields update with the same number when i want each field to
have different numbers... You help is very appreciated
The method of using insert and values to add data to a table works very well
to do one record as you have found. To update several records at a time
instead of the values part of the query, you need a select query t...Index Match Functions
Has anyone ever combined the Index and Match functions to do lookups?
...How do I import large data files?
When I try to import a data file with more rows than Excel, the text box says
I can import the rest by re-importing the file and excluding the lines
already imported. The Import Wizard doesn't seem to give me this option...
XL: Importing Text Files Larger Than ???? Rows
Regards Ron de Bruin
"Russell Seguin" <Russell Seguin@discussions.microsoft.com> wrote in message
> When I try to...Not matching transactions
I have it set to not automatically do anything. I've tried resetting the
account quite a few times with the help of technicians, but it's too long and
involved, and I'm tired of rebalancing the account every time.
I have 3 accounts, 1 works without passport and does fine. One of the
others I can manually download from the web site, and have no problems doing
it like so and decided this is the best way, prior tries it wouldn't work
with passport. But the other still insists they are new transactions, and I
can't download from their site directly. They only allow...Extract X data from Chart
I have looked through the information provided by this group for chart
events, and I have a good code to get the embedded chart to show the message
box with the point information. (Thanks Jon Peltier)
What I would like to do now is to extract that X data and paste it into
another area of the workbook to run some other analysis.
Is there some way to have the X value be copied into another cell on another
I am using this code in a MouseUp event:
Dim ElementID As Long, Arg1 As Long, Arg2 As Long
Dim myX As Variant, myY As Double
' Pass x & ...refresh external data on a protected sheet
I have a worksheet that has an external data area and some other sections
that need to be protected. I have unlocked all the columns used by the
external data. When I protect the sheet, I can no longer refresh the external
data area. Even if the entire worksheet is unlocked, the Refresh button is
...Scatter with Dynamic (Array) Data
I'm trying to create a scatter plot using Array's instead
of using Cell's in a worksheet but can't seem to get it to
work. Here's what I'd LIKE to be able to do but it keeps
bombing. Any ideas?
Dim myXvalues(1#, 2#, 3#) As Double
Dim myYvalues(4, 2, 4) As Double
ActiveChart.ChartType = xlXYScatter
ActiveChart.SeriesCollection(1).xvalues = myXvalues
ActiveChart.SeriesCollection(1).Values = myYvalues
I figured out the problem. Or, more correctly stated, I
figured out a way aroun...Data Validation/Fill question
I have a cell in my workbook that I would like to have filled from a
dropdown list. The possible option number about 30 so a "Data Validation"
would be unwieldly unless I could nest it, as the possibilities fall into 3
to 4 catagories. Is there a way to do this? I thought about a combo box,
but I want the same dropdown to be usable by approx. 120 cells. Is there a
macro that could be done in wich I select the cell and then a pop-up window
will allow the fill, or some way around this?
I am using Excel 97.
I think this might be a good place to start:
http://www.contextur...Error message regarding updating american express data
When updating my accounts online I receive a message indicating there was an
error downloading from american express. It indicates the account may be
closed or the number may have changed. Neither is the case, and the update
completes and downloads the data from american express correctly.
Any suggestions on eliminating the message?
AMEX has been having problems for the last two days and I can't even sign on
to the AMEX website this morning to THAT get that message today. It appears
to be an AMEX problem based on the message on their website yesterday.
I have a pivot table with customers orders updated every week. The thing is
that as I just update the information every week, the combo boxes of the
pivot table retain all the clients I ever showed (over 2000), even though
most of them are not used. Is there a way of cleaning up this combo list
other than creating a new pivot table?
There's information here on clearing old items in a pivot table:
> I have a pivot table with customers orders updated every week. The thing is
> that ...Excel pivot tables using Access as the data source
I can successfully create the link between my Excel pivot tables to my Access data base, however Excel will only look for the data in the specific path in which it was created. How can I have my pivot table find and read the Access data even if I move the Access file to another directory
This mainly causes me problems when I distribute my Excel reports. I bundle the Access database with the Excel report but my instruction to the receiver must instruct them to create a specifically named folder under the C drive and store both the Excel pivot table and Access database otherwise the Excel p...