How to diffrentiate Text & number from a single cell????
Hi ther guyz............i a have small problem with the execl
my problem is e.g. i have alot of cells with a number and some text in
it........and they both are in one/single cell (e.g. "878 queen st" in
A1)....now what i want is to remove let's say "queen st" from each cell
so that there is only number left in it.....................i cannot
figure out any formula........if there is any..............need help
pack_card2000's Profile: http://www...Delete cell contents while retaining formulas
I want to delete cell contents from cells I select without deleting the
formulas. How do I accomplish this?
Thanks in advance..
- select your range
- hit F5, click 'Special' and check 'Constants'
- now hit the DEL key
"Dave A." <firstname.lastname@example.org> schrieb im Newsbeitrag
> I want to delete cell contents from cells I select without deleting
> formulas. How do I accomplish this?
> Thanks in advance..
...Protected cells and grouping
I have a spreadsheet that I am using grouping to expend and compress
associated lrows of date. Within the group I want to protect some rows.
However, I find that when I set this up the grouping no longer functions.
Is there a way to set this up so I continue to expand or compress the group
and still protect some of the rows of data within the group?
Have you thought of using a userform with mutitabs etc to view the sheet.?
> I have a spreadsheet that I am using grouping to expend and compress
> asso...Copy Cells with VBA
I'd like a VBA macro that would copy in row C4 of worksheet A the content of
row E11 of worksheet B.
Is that possible ?
If both workbooks are open try this
I think you mean a range instead of a row?
Workbooks("A.xls").Sheets("sheet1").Range("C4").Value = _
Regards Ron de Bruin
"Jeff" <Jeff@discussions.microsoft.com> wrote in message news:637A2067-D2D9-4607-B2D2-B03884429075@microsoft.com...
> He...Deleting 1 folder across multiple Mailboxes
We created a duplicate junk mail folder and want to delete it across multiple
mailboxes. Is there a utility that will do this or do we need to open each
mailbox individually? We have 1200 mailboxes.
Exmerge.exe will do this...it is available at download.microsoft.com.
"Griff" <Griff@discussions.microsoft.com> wrote in message
> We created a duplicate junk mail folder and want to delete it across
> mailboxes. Is there a utility that will do this or do we need to open
&...Deleting N/A value in a spreadsheet with V-Look Up
I have a large spreadsheet of Data that contains a Vlook up to anothe
sheet. I need to sum the figures however the V-Look up is returnin
some N/A values which the autosum doen't recognize. How do I delet
these or make them equal to zero?
JOConnor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1661
View this thread: http://www.excelforum.com/showthread.php?threadid=31482
you may change your formulas to
or for...blank cells #4
How do I copy and paste...and OMIT blank cells..
Select the range of data, click Edit>Goto>Special and
select Contants; non-blank cells will be selected this
way. Next, carry out normal copy and paste procedures.
>How do I copy and paste...and OMIT blank cells..
...Chart with merged rows
Another question for EXCEL gurus !
I have a chart with 56 rows (corresponding to 56 weeks in a year),
each of which is composed of merging 7 rows (corresponding to 7
days/week). How can I get a graph with the values in these merged
columns ? Selecting these and clicking the chart icon does not produce
X-axis C, Y-axis - D
A B C D
13. Aug. Sunday ...Unable to Sum cells in Excel
I am having issues trying to use the SUM function to
autosum a couple of cells that have If functions within
them. I am trying to do the following:
In Q12 I am trying to get the Sum of N12, O12 and P12. I
have only tried =SUM(N12:P12) as the function formatting
the cell as text, general, numeric etc but the total
always ends up being 0.00, I never get an addition of the
values in the other cells.
Each of the N, O and P cells has the following function
(F12>=78%,"...pasting 1 cell into merged cells
Is this possible at all?
I get an error: cannot change part of a merged cell.
this is one of the drawbacks of merged cells. Therefore try to avoid
these kind of formating
Dominique Schroeder wrote:
> Is this possible at all?
> I get an error: cannot change part of a merged cell.
You can get around the error message by pasting into the function lin
above the worksheet.
Look for the fx just above your lettered columns,
click just right of the fx in the white line
and ...selecting cells #3
When working with a large group of cells, I find it easier to click the top
cell, scroll to the bottom, and click the last cell while holding the shift
key down. The problem is, when I want to select a second column of data, I
have to select the top cell using the control key, the pull down the cursor
manually. Is there a way to select 2 or more non-adjacent columns without
having to scroll down using the mouse?
Nevermind - figured it out myself. The easiest things are often so obvious
they are hard to see.
> When working with a large group of cells, I...Merging text files with excel
How can I merge several text files with the same format into one Excel sheet
in one go ?
I am importing them singly but it would be much better to merge them
together before opening.
Many thanks for any help !
Maybe you can use some old DOS commands.
Shell to a command prompt and issue an old DOS command to concatenate the Text
Windows start button|Run
(or flying windows r as a shortcut!)
Go to that folder:
(to change to that drive)
to change to that folder
copy *.txt All.Files
Ren All.Files All....zero values become negative notation
1 value of a cell minus another similar value of another cell = a negative
value with a negative notation power. Is this a bug?
Maybe the two values are not exactly the same. Could this be IEEE round-off
Chip's clear explanation
Floating-point arithmetic may give inaccurate results in Excel
(Complete) Tutorial to Understand IEEE Floating-Point Errors
What Every Computer Scientist Should Know About Floating Point
http://docs.sun.com/source/806-3568/...Wrap text, Merge cells
I have merged 2 cells in a column, wrapped the text.
There are actually 20 rows of data ( sentences) in one cell
After the 18th row within that merged cell the data is no longer visible.
Is there a limit to how high a cell can be ( mine is at 350, but can be made
a whole lot large, not that the data is visible though) or how many "rows"
wihin a merged and wrapped cell are possible?
Stumped in IN.
thanks for any info on this subject
A row's height (with or without merged cells) cannot exceed 409. Also, a
cell can display only about 1000 characters even though it can hold ov...popup calendar with multiple months
I currently have popup calender in Excel to fill in cells with the date. I
would like to be able to view 3 months at a time How can I change my set up
to allow this.
...Length cell limited ?
It is needed to insert in a combined cell a chain of but of 1500 characters
however happens the following thing:
although the information is complete in the cell, the chain is visualized
partially since in form alone the first 1170 characters appear.
It has been to modify the format of the cells but the complete information
Any help will be welcome
Why do you need so much information in a single cell?
Is it because it's a formula? The way I have found around this problem is
to break the formula down into 2 cells resulting in a 1 or 0 and have a
third ce...HELP WITH A MAIL MERGE
...How I can set highlighted active cell in row & colmun cross
I want to set active cell highlighted in row & colmun cross as it was
possible in Lotus 123. Is it possible? if yes, how is it?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
...If formula that looks at multiple cells and values, and then calul
I'm trying to put together a production spreadsheet for mechanical
manufacturing that figures out a length of one piece of material based on
other dimensions. It's for storm shutter parts and the cut dimensions need
to be calculated from the field measures. There are many types of tracks
available and the blade length is dependant upon the finish height, track
type and structure. I need the formula to look at 5 different cells that may
or may not have data for the top track and only use the data from the one
that's filled out. Same for the bottom track for a total of 10 ...Error in Mail Merge when selecting Edit Individual Labels
We are noticing an interesting error when trying to perform a mail merge
within CRM and Microsoft Word. We have created a view in contacts and we
perform all the typical mail merge functionality using the Labels option. At
the end, instead of printing the labels without any edits, we click on “Edit
Individual labels” and we get the following error…
C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE has encountered a
problem and needs to close. We are sorry for the inconvenience.
We are on CRM v4 Update Rollup 8 using Outlook 2007 and the CRM Outlook
(Online only) client.
Has an...can only see one page of a multiple page publisher file
today can only see the first page of a file in publisher....checked the
attributes removed the read only....could not remove from overall i.e. my
documents...can pull up on another computer via network and see all....so
file appears to be okay...can also print all pages, but can only see and work
with page one...HELP.....AND A BIG THANKS TO WHOMEVER!!!!
What happens when you try to click on the other pages? Do you have the
status bar turned on? (View - Status bar)
MVP Microsoft [Publisher]
"CON" <CON@discussions.microsoft.com> wrote in message
news:...VALUES ARE DIFFERENT THAN CALCULATOR
I am figuring my payroll on an Excel spreadsheet. When I enter the formulas,
the values are sometimes off by a penny. On my calculator, I have it set to
5/4. How do I get my formulas to come out the same as the calculator?
Look in help for the ROUND function
Also see link for discussion of rounding issues
> I am figuring my payroll on an Excel spreadsheet. When I enter the formulas,
> the values are sometimes off by a penny. On my calculator, I have it set to
> 5/4. How do I get my formulas to come out...How to prevent cell reference incrementing
I have an issue with a spreadsheet in that I want a calculation to
always use the same cell in a calculation.
I have placed the $ signs before the letter and number references and I
have even tried defining a name for the cells concerned but as soon as
I insert a line above the whole equation is offset which causes
Is there a way to totally lock into a certain cell either through using
the name or with special characters ?
Put the address in a cell as text (let's say in A1)
<email@example.com> wrote in message
news:...Can you apply split colour formatting to the same cell?
Hi, I'm looking to apply more than one colour format to the same cell, split
diagonally from right to left (one colour being orange, the other being
white/uncoloured). I don't want stripes, just two blocks of colour making up
the cell background.
Slightly bizarre question, I know, but it's for a work diary for a
department with colour representing 'busy' and white/uncoloured representing
'available'. As I'm busy for the first half of the day, I want to split the
cell in half. At the moment I just have a diagonal line and the whole cell in
orange, but wan...Merging Data into Word and Want Checkboxes (Yes/No data type)
I am trying to merge data from my access database into word. I have several
items that are checkboxes in access. How do i get those checkboxes to merge
into word so that i see them. Right now they just produce numbers if they
are checked or not. Thanks
I'm not sure you can do with with a straight mail merge. The following is a
snippet of code from one of my applications. The app relies on documents
that have already been bookmarked with simple bookmarks (for fields longer
than 255 characters), checkboxes (for y/n fields), and textboxes for
everything else. The merging is d...