total number of characters in a cell
Is there a function that can count the total number of characters in a cell?
The LEN function will return the total number of characters in a
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"plumstone" <email@example.com> wrote in
> Is there a function that can count the total number of
characters in a cell?
Note that this includes space and other non-printing characters.
In article ...Remove . (period) from merged data
I have a Word 2003 doc that merges data from our database, including a ref no
which contains a period as part of its format (e.g. 10.001).
We now need to remove the period from the ref no once merged in the Word
doc, as another company who receive the document (shipping company) are
having problems with it. They need it to be shown as 10001.
We cannot/do not want to re-format the ref no in the database itself, as it
serves a useful purpose for us.
Is there a way to "code out" the period once the ref has arrived in the Word
doc, perhaps by using a numeric picture switch o...Cells get automatically converted
I want to store installment details of employees in the format: 9/15,
10/15 etc.. These are text values and are transferred via .NET
application to Excel. But it considers it a date and so converts 9/15
to 15-Sep, 10/15 to 15-Oct. I even searched for options to disable
this, but could not find it. Please help switching this off.
In message firstname.lastname@example.org,
RP <email@example.com> Proclaimed from the tallest tower:
> I want to store installment details of employees in the format: 9/15,
> 10/15 etc.. These are text values and are transferre...Grouping like coloured cells
I have a conditional format set up to change cells different colours
when certain conditions are met. I want to be able now to set up a
separate table with all the same coloured cells in. I'm sure this is
possible, however, I also want to be able to copy the row title into a
section of the new table. Is there a way to do this?
I have just changed the format of the chart. All I need to do now is
form three seperate charts of positives, negatives and neutrals,
however, they still need to be linked to the original row title.
...Insert Worksheet Name into a cell
I've been trying in vain to solve this problem.
I work with multiple worksheets and part of my title has th
worksheet's name. Right now, for each title, i edit the title
Is there any function like the = cell("filename") that extracts th
filename that can work on extracting the sheet name instead.?
Thanks in advance.
Message posted from http://www.ExcelForum.com
Provided the workbook has been saved, you could use
"Pr...Format all cells containing formulas
I'd like all cells which contain calculated values to show up in
different color (or some other formatting change). I know I can toggl
formula fields to be visible and manually update each one individually
but I'd ideally like something that automatically formats new formul
cells (and even applies to new .XLSs and worksheets). Seems like a
obvious thing to want to do, but haven't found this anywhere in th
A usable fallback option would be a macro to search the worksheet an
apply (eg) Red Bold to every cell containing a formula.
Message posted fr...use command button to total datas in cells through VBA codes in ex
how can i establish a new command button in combo box to total datas in cells
by wrinting VBA codes ??
thanks you !
...Drop Down Boxes for Validation Cells are Too Wide
For some reason, in some columns of my spreadsheet the validation drop
down boxes are too wide for the cell. In column A, for example, they
will be the width of the cell plus the dropdown arrow - perfect. In
column C they will exceed the width of the cell plus the drop down
How do I fix this?
Extra wide dropdown lists appear occasionally, usually if cells on the
worksheet have been merged (not necessarily the cell with the data
To get rid of them, you may have to delete the row or column and
recreate the data validation.
> For some reason, in some...I'm trying to merge 2 workbooks into 1 new workbook.
I need assistance on merging 2 workbooks in to 1. Information may or maynot
be different in each workbook. Can this be done??
...Access Databases merging when syncing PDAs with Handbase
I have a probelm with seperate Access databases merging when PDA's are
sync'd back to handbase.
I have created a a handbase database created with Data Exchange to get
the data into it.
I then have a blank Acess database where the table etc etc match the
I then out it onto several PDA's and data is collected. Then the PDA's
are docked and the data updates in the Acess database.....all good !!!
The work is carried out in serveal areas so I make a new database for
each area........the probelm is thugh sometimes when a PDA is docked
all...Error Message when sending mail merge
I keep getting this error message when attempting to send a mail merge e-mail
from one of my campaigns.
"You do not have enough privileges to access the Microsoft CRM object or
perform the requuested operation. For more information, contact your system
administrator. Do you want to send the e-mail? If you clik Yes, the e-mail
will be sent out, but no corresponding activity will be created in Microsoft
I defintley want this activy to be recorded, any ideas?
This is really strange. I have three contact inmy marketing list, I get this
message only for the first two and ...protecting cells (Excel 2000)
How do I prevent certain cells from being altered, allowing
users to enter data only in certain areas.
I can only see how to protect an entire sheet or workbook.
first select the cells for which you want allow entries. Goto Format -
Cells - Protection and uncheck 'Locked'. Now protect the sheet
"David Kinston" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How do I prevent certain cells from being altered, allowing
> users to enter data only in cert...cell color #4
is it possible to auto change cell color depending whether there is a yes or
no in the cell...i want to make the cell turn red when i enter yes
read about Conditional Formatting
=LEFT(A1)="y" or if spelled out
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"kd" <email@example.com> wrote in messa...moving cells to new sheets
I am trying to tidy up a fairly large and complex workbook
that is all (quite confusingly) kept on one sheet.
Is there any way to move cells to other worksheets and
have them hold on to their original reference from the
e.g. easily copy cell from Sheet 1 with say, (=R1/2) to
Sheet2 so it now has the formula (='Sheet1'!R1/2)
Try: Cut (from Sheet 1) > Paste (in Sheet 2)
D Abramovich <firstname.lastname@example.org> wrote in message
> I am trying to tidy up a fairly large and complex workbook
...Adding Formula to Cell with Data
Column A has hard coded data. I need to add to the hard coded data figure
another cell. I do not want to insert a new column or change the format of
my worksheet. How can this be done without manually adjusting each cell?
> Column A has hard coded data. I need to add to the hard coded data figure
> another cell. I do not want to insert a new column or change the format of
> my worksheet. How can this be done without manually adjusting each cell?
What type of data in the cells?
If numbers and you want ...Cell Character Display Limit
I have numerous cells with over 3500 characters in them. In one case, only
about 2000 characters are displayed. Is there some way to get all the
characters to display. Must I format the cells a specific way?
Place ALT+Enter periodically in the text, say every hundred characters
Barb Reinhardt wrote:
> I have numerous cells with over 3500 characters in them. In one case, only
> about 2000 characters are displayed. Is there some way to get all the
> characters to display. Must I format the cells a specific way?
> Bar...Anchoring cells
I have a spreadsheet I am working on where I have 4 columns of
demographic information followed by 12 columns for their status during
specific months. I would like to anchor the 4 columns and then be able
to go the month in question. I want to be able to see the demo
information next to the cell for that person and that month. HOw?
Xcel 2004 for Mac if you need the information.
Thanks for any help.
I want to find a voracious, small-minded predator
and name it after the IRS.
Robert Bakker, paleontologist
Place your cursor in cell E2>Windows>Freeze Panes
This w...Extract data from a cell after a constant value
I have a spreadsheet that contains 1 column of data, if the cells of the
column are the city names and populations of towns in the following format:
Appleton, Wisconsin (WI) (pop. 70,087)
The 'pop.' is always present.
I want to extract just the population number (ie: 70,087) from these cells
into another cell.
What is the simplest way to accomplish this?
On Sun, 19 Aug 2007 12:29:37 -0500, "Wolfman" <email@example.com> wrote:
>I have a spreadsheet that contains 1 column of data, if the cells of the
>...linking cells from different files -fill down
I'm trying to fill the same formula (links) down a column on
I'm linking from the same cell from a months worth of files,only th
file reference is changing as shown below.(11-1-05,11-2-05,etc..)
singlgl1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2638
...Print multiple mail merge results on each postcard page in Publish
After creating a postcard in Publisher and successfully completing a mail
merge, I only seem to be able to print one "addressed" post card per page.
When I choose multiple copies (4 per page), I get the same addressee 4 times.
Is it possbile to print 4 mail merge results on a single page, to minimize
Are you actually printing the cards or relying on what print preview is telling
Print preview shows all the cards the same, it is a bug in the program.
For a mail merge to be successful you can only have one card on your screen.
Mary Sauer MSFT MVP
http://...how can i susbstitute the symboals like '-' or��#�� in the cell?
till now ,the excel only support substitute the text in the cell,as we can
use SUBSTITUE function.
But if i want to substitue the symboals like ��-�� or��#'��how can i do?
On Thu, 13 Dec 2007 09:12:47 +0800, "Sebation" <firstname.lastname@example.org> wrote:
>till now ,the excel only support substitute the text in the cell,as we can
>use SUBSTITUE function.
>But if i want to substitue the symboals like ��-�� or��#'��how can i do?
What was wrong with using the SUBSTITUTE function?
How can I count the number of times each of numerous
items appears in a column? That is, I have a column
Each entry represented by a letter above is in fact
several words. There are about 10,000 rows in the
table. I would like result like
Thanks in advance.
You can use the countif function, say for example you wanted to find the
number of occurances of the letter a in the column (which is column A)
If you have many entries you could have a table of the occurances you are
looking for and inste...Formating of cell size-
Hi- It should be simple but I can t figure it out. Cells are locked to size
from top to bottom of document .Yes I can adjust the heights and widths but
how do I format some cells in the bottom of a document that I dont want to be
the same size as ones a little higher in the document. ?
Row heights and column widths are the properties of the entire rows and columns.
IF you will not use the sheet for anything but appearance only I could suggest
using the "merge cells" feature.
I hesitate to make this suggestion due to the problems created by merged cells
whe...How to change a color of a cell using a condition formula
I would like to change the color of a cell automatically using a condition
formula.....is this possible?
Yes, go to Format | Conditional Formatting.
Juan Pablo Gonz�lez
"Carlos" <Carlos@discussions.microsoft.com> wrote in message
> I would like to change the color of a cell automatically using a condition
> formula.....is this possible?
see 'Format - Conditional Format'
> I would like to change the color of a cell automat...Rounding formula won't copy to other cells in column
I have a formula in cell G2 that reads: =round(F2,0). I'm using this to
round the value in cell F2 and remove decimal places. The entire "F" column
has values I want to round, and I am unable to "fill" the formula so that I
can get the rounded values of each record in the range. What should I be
So what *does* happen when you copy the formula in G2 to other cells in
the column? Check to make sure Calculation is set to Automatic
In article <1933354D-C4AE-4051-87BD-29AF728A57DA@microsoft.com>,