I need a formula
I need a formula that would allow me to copy one cell to another as
well as remove the first three characters.
cel a - 12321232 would copy to cell be as - 21232
If anyone could help me that would be soo awesome
Try one these
If the lenght of your data is fluctuating then
If you need them to return a number instead of text
then tack *1 on the end of them.
"RBD" <email@example.com> wrote in message
>I need a formula that would allow me...delete empy rows
I have a sheet with 3000 lines, I am using only thre coomns A, B, C
How can I delete all rows that has empty cells in colomn C
i.e. row 5 contains Sam in colomn A , 2 in colomns B , nothing in colomn
C. I want to delete this row
row 6 contains 3 in colomn A, nothing in colomns B, 34 in colomn C.
I want to keep this row.
can this be done
Try this on a *spare* copy ..
Select col C
Press F5 > Special > Blanks > OK
Right-click on the selection > Delete > Entire row > OK
GMT+8, 1� 22' N 103� 45' E
xdemechanik <at>y...new mail not showing in Inbox in O2002
I find that emails do not show in my Inbox until I go to
the Calendar, or other 'space' in Outlook. As soon as I
leave the Inbox, I get the signal that new email has
arrived and sure enuf when I go back to the Inbox, there
are the emails. This has happened repeatedly. I'm sure
that my being in the Inbox is the problem. Anyone have a
I have same problem plus no sound when they do arrive?
Same with you? Are you web base mail?
>I have the exact same problem and it seems to be very
>consistent. If you find any t...Unhiding rows
In Excel 2000, someone has hid the first 45 rows of the
worksheet. I can't unhide them. The sheet is NOT
protected. I tried various things including Edit/Go
to/A1/Format/Row/Unhide but nothing works. Any clues?
.......Baffled in Ontario
Granite Shoals, TX
"Connie" <firstname.lastname@example.org> wrote in message
> In Excel 2000, someone has hid the first 45 rows of the
> worksheet. I can't unhide them. The sheet is NOT
> protected. I t...Outlook 2003 New Install Config Issues.
I've just had my PC reimaged and Outlook 2003 reinstalled. My PST file
has been imported and my mail is where it sholud me.
Problems is the veiws had changed from what i had before.
For example, all folders now have gridlines between emails. I know how
to remove these in customise view but is it possible to change the
veiw for all folders at once or do i need to do each folder
"moox7" <email@example.com> wrote in message
> For example, all folders now have gridli...New to RMS: Having trouble setting up 2nd terminal.....HELP
We have an existing customer who has 1 server and 1 POS terminal. I have
recently installed a 2nd terminal and am trying to match the settings and
templates of the register 1 to the new register 2. The problem is with the
on-screen keyboard. I've chosen the option to use the touchscreen keyboard in
manager for register 2 and picked the template for the pre-configured
keyboard layout; however, register 2 just refuses to display the template
like register 1 does. I know ive got to be missing something.
By the way, i forgot to mention that yes, i have enabled the touchscreen
keyboard ...selecting rows using a variable
I am using excel 2003 and I need to select rows using a variable. Here is
what I have now:
Dim name As String
name = Range("e800")
Selection.EntireRow.Hidden = True
Dim Start As Integer
Dim finish As Integer
Start = Application.WorksheetFunction.Lookup(name, Range("Q800:Q881"),
finish = Application.WorksheetFunction.Lookup(name, Range("Q800:Q881"),
ActiveWorkbook.Sheets("individual stats&q...select and delete all blank rows
I could save a lot of time if I knew how to select and delete all blank rows
from a document, and also separate things. An example of separating things
would be a list contains fruits, vegetables and meat. I could separate all
the fruits from the list easily.
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
clic...Formula help! #2
can someone help me where i have a row of numbers that go
0, 0, 0, 0, 0, 5, 10, 5 etc... from cells D2:K2
i want a formula to put in A2 that returns the first non-
zero number, ie. it would return 5. it would also be
useful to have a formula that returns which column the
first non-zero number occurs in.
any ideas? thanks
First non-zero (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
where rng is your range reference (e.g., D2:K2).
Column the first-non-zero occurs in (also array-entered):
=LEFT(ADDRESS(1,3+MA...Formula Format problem
I am using the following format to query another sheet and return data.
It works great for part of my needs, but not for all. In the next column I
need to do essentially the same thing plus divide R$5:R$251 by Q$5:Q$251 but
everything I have tried comes back as an error.
I'd really appreciate some help with the syntax since I am pretty sure it
can all be done, but I just don't know what I am doing!
If not- I realize I can add additonal columns and then hide them to simplify
the fo...How do I copy only subtotals to a new sheet?
Not including selecting each one individually.
Select the range, press F5, select special and visible cells only, copy and
> Not including selecting each one individually.
The way I do it is to set the grouping to display just the totals. Hit F5
and from Special select visible cells. Copy and Edit|Paste Special|Values
where you want them to go!
"darlinvee" <firstname.lastname@example.org> wrote in message
> Not including selecting ...new excell will not read old excell file
I have just installed office home and student into a new computer but when
try to run one of my existing file it tells me it is corrupt. It runs fine in
the old computer. please help
What versions of Excel are involved? XL2007 can read and write both
the new formats (xlsm, xlsx, xlsb) and the old format (xls). Unless
you have the Office Compatibility Pack
(http://support.microsoft.com/kb/924074/en-us) installed, XL2003 can
read only xls files -- it cannot read the new file versions. Since
2003 has no knowlege of the new formats, it assume the file is
corrupted. Of course, a file...Reintstalling Office 03 on a new machine, Excel does not appear
Had to put a new hard drive in my notebook, and reinstall XP home and all my
software. Reinstalled Office from original disks, and most of it works. Word
is fine. However Excel does not appear in Start/All Programs or anywhere
else. Tried three times. What's up?
Try Start>Run excel.exe
When you re-installed was it a "typical" or a "custom"?
Start>Settings>Control Panel>Add/remove programs.
Scroll down to Office 2003 and change/remove.
Follow your nose from there and you can see if Excel has been installed.
Hav...exchange 2003 mailbox can't read new mail
I have a problame - My Exchange 2003 sp2 hase started to get mail but i
can't see the mail , Ihave chacked the mailbox DB' IT IS OK, I did
disasterrecovery, but the problam is the same, i can see old mail but not the
new mails ?
What can it be ?
???? <@discussions.microsoft.com> wrote:
> Hi all
> I have a problame - My Exchange 2003 sp2 hase started to get mail but
> i can't see the mail , Ihave chacked the mailbox DB' IT IS OK, I did
> disasterrecovery, but the problam is the same, i can see old mail but
> not the new mails ?
> What can it be...Rows to Columns
I have data arranged in rows across a spread sheet, for example B2, C2, D2,
How can I change that to a column, for example A1, A2, A3, etc without
reentering all the data?
--Select B2:D2. Copy the range
--Select A1. Right click>PasteSpecial>Transpose>OK
If this post helps click Yes
"Walter Seaton" wrote:
> I have data arranged in rows across a spread sheet, for example B2, C2, D2,
> How can I change that to a column, for example A1, A2, A3, etc without
> reentering all the data?
>...65536 Rows for how long????
I was wondering: is Microsoft planning on expanding the 65536 row limit?
They most deffinitely should!
"Albert" <Albert@discussions.microsoft.com> wrote
> I was wondering: is Microsoft planning on expanding the 65536 row limit?
> They most deffinitely should!
Well, not "certainly", but its certainly my opinion.
I think 65536 is not enough. I believe that, among other things, Excel was
made for managing large amounts of information efficiently. I think that in
this d...Including number format in formula
I have a simple "if/then/else" formula that I would like to display
the result of the "else" portion with no decimal places showing,
instead of the default value of the cell. Can I include the format in
the formula? Here is my formula:
Zilbandy - Tucson, Arizona USA <zil@zilbandyREMOVETHIS.com>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
or replace Int with roun...change range of relative formulas to absolute
Excel 2003. I'd like to change an entire range of cell formulas from
relative to absolute.
You would need VBA to make global changes to cell references.
Here are four........
Dim cell As Range
For Each cell In Selection
If cell.HasFormula Then
cell.Formula = Application.ConvertFormula(cell.Formula, _
xlA1, xlA1, xlAbsolute)
Dim cell As Range
For Each cell In Selection
If cell.HasFormula Then
cell.Formula = Application.ConvertFormula(cell.Formula, _
xlA1, xlA1, xlAbsRowRelColumn)
I am trying to make a barcode that will enter a static time into a cell
and move to the next cell (right)
I have 3 of 9 barcode fonts. There is no = sign nor is there a symbol
Does anyone know how to do this.
Other choice would be a button on a toolbar but would like to not have
the person return to the computer each time to enter.
Any help please.
pgriff's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26189
View this thread: http://www.excelforum.com/showth...Formula entries get turned into textual entries
I received a workbook from another company and wanted to add a new
column of formulas. However, even though I included the = sign and
ensured the correct formula, my entry into the cell would suddenly
convert it to text, showing a ' or ^ character in front of the = sign.
I discovered if I clear all formatting and data entry from the cells,
it would then allow me to enter formulas. I've also found that if I
create new workbooks/spreadsheets, this does not happen. I experience
the same odd behavior in 2003 and 2007. This suggests there's
something wrong with the file the other compan...Two formulas in on cell based on two numbers in another cell?
Not sure this is possible but...I have a cell that has a number range in it
and based on an amount in another cell want to calculate a new range. For
Initial Range: A1 = 10 - 12
Calc Amount: A2 = 5
Final Range: A3 = 50 - 60
I think I can get the results by concatenating two formulas I'm just not
sure how to enter the original numbers (A1) or how to distinguish between the
two in the final formula (A3)
Using Excel 2003. Hope this makes sense. Thanks.
I would put the range in two different cells (eg A1 and B1). Then the
multiplication is easy. If you ...Text Formula Question
In COL A, I have a list of 2 and 3 digit charactors. I would like to
seperate each string into the three adjacent columns.
KQ K Q
AJs A J s
TT T T
89s 8 9 s
I know that I can use the Left function for the first col, but cant
figure out how to get just the middle or third letters.
Thanks in advance,
Check your last post!
Please keep all correspondence within the NewsGroup, so all may benefit !
------------------------------------------------...adding a new user to email
okay so i have tried so many time to add my husband onto
outlook email but for some reason it will not allow me to
do so and it really is driving me mad! this is the steps
i am taking...
Does he have a separate account? Have you added this account from Control
Panel->Mail Icon? What version of Outlook are you using?
BTW - the steps you listed are going to elicit the same problem every time.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
A...sending previous "contacts" to new "contacts" folder
I've attempted to send my old contact list to 'Windows mail' but have not
been successful at this point. What am I doing wrong?
What do you mean by "send" your old contacts? Where are the old contacts
located, on a different computer? If so, which mail program were you =
on the older computer?
Gary VanderMolen, Microsoft MVP (Mail)
"Bonnie " <email@example.com> wrote in message =
> I've att...How can I color every other row
I want to make it easier to use a large spreadsheet where two rows are
used for each record. Filling in the background color of every second
row prevents mistakes when entering data. I want to color only the
used range, not the entire row.
I recorded a macro and got the following:
.ColorIndex = 36
.Pattern = xlSolid
I really appreciate the help.
Dim iCtr As Long
For iCtr = .Row To .Rows(.Rows.Count)....