A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
how do i separate numbers and text in a cell? by Jan
i have the following text string "Home: installation on Cognos (5.5 hrs)" the number represents the number of hours i want to have separated from the text"...
(Multi-page thread 1 2 3 ... Last Page)
June 13th, 2007 12:51 PM
by Dave Gibson[_2_] Go to last post
34 207
dot on numeric keyboard pad is replaced by comma by Picsou
Hi, I have the followin question : In Excel 2007, the dot on numeric keyboard pad is replaced by a comma. This happens only in Excel 2007, not in Word 2007...
(Multi-page thread 1 2 3 ... Last Page)
February 3rd, 2009 03:40 PM
by Bob I Go to last post
32 272
Unacceptable floating point errors by Jeff in GA
This is NOT some calculation to the nth place or an atomic weight. This is: .29 - .28 Instead of returning the correct answer of 0.01, Microsoft Excel...
(Multi-page thread 1 2 3 ... Last Page)
September 25th, 2009 11:26 AM
by Simon Murphy[_2_] Go to last post
32 393
Getting all rows of data that have a value in a particular column by Rikki-Handgards
Hi. Is there a way to list, on a separate sheet, only rows of data with a value in a specific column? I want to list inventory items (and all data in that...
(Multi-page thread 1 2 3 ... Last Page)
December 10th, 2007 01:29 PM
by Tanya Go to last post
32 279
Import data into seperate columns by naulerich
I have a .txt file that looks like: "123","test text","this is a test","abc" I want my output in excel to be the following: A1=123 B1=test text C1=this is a...
(Multi-page thread 1 2 3 ... Last Page)
April 4th, 2006 09:22 PM
by Ron Rosenfeld Go to last post
32 475
Random Number by jon
Is there a way to create a 40 by 40 sheet where each column and each row have no duplicate numbers. And have this randomly generated?
(Multi-page thread 1 2 3 ... Last Page)
January 26th, 2007 04:10 PM
by Dave Peterson Go to last post
31 207
ByVal Target Range Great Code but need Help by Mark
I am getting help, yet I need further help. The formula I post below, works for B3 and to the right. I need it to work exactly the same from B3 thru B100 and...
(Multi-page thread 1 2 3 ... Last Page)
July 27th, 2007 03:11 PM
by Bernie Deitrick Go to last post
31 189
Select specific text in cell by John Gregory
Is there a simple way to extract text in a cell that occurs between specific characters, or to the right of a special character? The text strings are various...
(Multi-page thread 1 2 3 ... Last Page)
February 17th, 2008 02:09 AM
by Rick Rothstein \(MVP - VB\)[_43_] Go to last post
30 182
Macro basics by Dallman Ross
I'm trying to develop some macros. I'm not that versed at it yet. Here is part of something: Dim iLastCol As Long With Worksheets("2006...
(Multi-page thread 1 2 3 ... Last Page)
November 20th, 2006 02:15 AM
by Dave Peterson Go to last post
30 178
Getting #DIV/0!, how to get 0%? by pgarcia
I'm getting #DIV/0! with the following formula, the cell is format as a percent. Thanks =(E34-D34)/E34 E34 = 0 D34 = 0 Result should be 0%
(Multi-page thread 1 2 3 ... Last Page)
February 19th, 2010 11:15 PM
by Gord Dibben Go to last post
30 897
How do I link cells, sheet to sheet, to recognize row deletions? by LeeC
In Office XP - Excel - I want to copy a column from one sheet to another sheet in the same workbook. I want the copied links to recognize row deletions and...
(Multi-page thread 1 2 3 ... Last Page)
November 6th, 2009 11:26 PM
by purplec0ws Go to last post
30 565
UserForm Listbox issue by bach
Hi, After some searching on the forum I found a article which was what I was looking for. WHAT AM I DOING I have a sheet with data on it, I want to populate...
(Multi-page thread 1 2 3)
October 6th, 2005 01:48 PM
by Dave Peterson Go to last post
29 364
Find the first & subsequent cells to contain text in a column & re by M
I have a column that contains empty cells and text. I want to return the row reference of the cells that contain text. For example… A2 = empty cell A3 =...
(Multi-page thread 1 2 3)
July 26th, 2009 07:04 PM
by T. Valko Go to last post
28 139
Find Discontinued Number by plumstone
I have a spredsheet to a few columns and one of the field is check numbers. This column looks like this: Check # 101 102 103 106 107 109 110 ....
(Multi-page thread 1 2 3)
June 24th, 2004 11:17 PM
by AlfD Go to last post
28 532
Excel 2002 : How to get the difference in a block of data ? by Mr. Low
Dear Sir, I have the following worksheet data: A B C D Vehicle ...
(Multi-page thread 1 2 3)
December 10th, 2006 03:45 PM
by Mr. Low Go to last post
28 240
how to combine several files, all with same columns, into one shee by Landa
Let say there is 3 excel files. Each file has one sheet and the same columns, e.g. column A: product name column B: description Column C: Price How can I...
(Multi-page thread 1 2 3)
May 28th, 2010 06:19 AM
by Faisal Ijaz Go to last post
28 1,365
Entering a range of numbers and searching same by Penny
I'm working with numbered documents. Some clients have a range of documents (12003-12212) I want to search for document 12,198 and pull up the...
(Multi-page thread 1 2 3)
May 10th, 2006 03:38 PM
by Dave O Go to last post
28 293
Dragging formulas by Connie
I have a summary worksheet at the end of 12 other sheets, each sheet being the figures for the month. On the summary sheet I have, for instance, "Average...
(Multi-page thread 1 2 3)
September 10th, 2004 07:15 PM
by David McRitchie Go to last post
28 477
Making cells mandatory to fill in by abfabrob
I am creating an application form where I want users to fill certain cells in before closing the document. Does anyone have an idiots guide to doing this, cos...
(Multi-page thread 1 2 3)
August 4th, 2009 01:00 PM
by Pam M[_2_] Go to last post
27 297
is this even possible? by Bowmanator
i'm working on a shipping log that i do now by hand and would like to automate if possible. every load equals 1,000 and alot of the loads are split loads. ...
(Multi-page thread 1 2 3)
March 25th, 2010 06:35 PM
by Otto Moehrbach[_2_] Go to last post
27 500
Post New Thread


Display Options
Showing threads 21 to 40 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.