A formula that displays the last letter in a text
I frequently use text in cells. I use MID and LEN often enough, but
is there a formula that will display the last letter in a text that
will often vary in length. Thanks.
<MichaelRLanier@gmail.com> wrote in message
>I frequently use text in cells. I use MID and LEN often enough, but
> is there a formula that will display the last letter in a text that
> will often vary in length. Thanks.
=MID(A1,...Retrieving Data from a Column / Row to populate a cell
I currently have data supplied to me in an Excel spreadsheet that I to
I would like this to populate a cell reference, the problem I have is that I
cannot gather a train of thought to obtain the data from from a specific
There is a sample of the data supplied to me below
Name In Out Int
Greg 165 108 29
09 July 2003 42 34 9
14 July 2003 44 19 4
16 July 2003 40 40 8
17 July 2003 39 15 8
Andrew 125 43 9
1...Copy Cell or Column without advancing formula reference?
I have a spreadsheet with formulas referring to another worksheet. I need to
copy the columns however, each time I do, the formulas advance to another
cell. Which is an incorrect reference, skewing my results.
You need to modify the formulas to use absolute references. Edit each of the
cell addresses in the formula and put $ (dollar signs) in front of the column
> I have a spreadsheet with formulas referring to another worksheet. I need to
> copy the columns however, each time I do, the formulas advance to another
> cell. Which is an...Wrap Text from one cell to another cell
I want type all my text into C111 (1-3 pages worth). I want this text to
automatically wrap to D111 to E111 to F111 to G111, etc.
The cell appears to have a maximum limit of characters.
> I want type all my text into C111 (1-3 pages worth). I want this text to
> automatically wrap to D111 to E111 to F111 to G111, etc.
> The cell appears to have a maximum limit of characters.
Copied from the help file:-
Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.
Have y...How do I add a data series in a combination chart in PPT 2003?
I have a combination bar/line chart showing gross revenues and passengers by
month over a 3-year period. The gross revenues are bars on the primary
y-axis and passengers are lines on the secondary y-axis.
I am trying to add gross revenues and passengers for CY2010. I am able to
add a data series for the passengers, but when I try to add a data series for
the gross revenues, the chart treats it as a series on the secondary axis as
How do I add the series as a bar on the primary axis, or alternatively,
change the series from a line on the secondary axis to a bar on th...Independently Formatting Columns and Rows
Operating System: Mac OS X 10.6 (Snow Leopard)
Is there a way to independently format the width of a column on specific cells? In other words, if I wanted to change the width of the cells in the middle of the document, can I do so without affecting the width of the cells above it and below it?
On 2010-05-28 12:40:38 -0400, email@example.com said:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel Is there a way to independently format the width of a column on
> specific cells? In other words, if I want...[2007/ToDo List] Add-in to create sub-tasks?
ince Outlook is basically what everyone uses to sync a BlackBerry
with Windows, I'm stuck with using it.
However, I need to divide tasks into sub-tasks, and sometimes/often
set some start and/or due date to an task.
This is what the MS Outlook 2007 ToDo List UI looks like:
This is what the ToDoList from AbstractSpoon looks like:
Do you know of an add-in so that Outlook support this poor-man
alternative to MS Project?
"Gilles Ganault"...Add vendor order number to purchase order
When we send a purchase order to a vendor, that vendor assigns their own
internal sales order number to our purchase order. I need to be able to put
that number somewhere in GP that will allow me to locate one of our purchase
orders based on the supplier's order number.
There are some fields on the Vendor detail window by clicking the arrow
button by the vendor id. You might be able to use one of those fields.
Otherwise, Extender is the way to go.
Charles Allen, MVP
"Mike Davis" wrote:
> When we send a purchase order to a vendor, that vendor assigns their own
&...Text in textbox is indented?
I have typed some text into a textbox. Then I think I messed with some
text settings and as a result, my text is indented from the second line
of each paragraph onward.
Something like this:
The text in my textbox
****however as you
****can see it is
****the second line
If I start a new line
****first line is not
I've clicked the decrease indent button many times but that doesn't
...add functionality to RMS calendar
the calendar is a good function to have. Expanded functionality would be
great. Design it as a watered down version of Outlook - set individual
appointments that can be assigned to individual customers. That way you can
search the calendar to see what appointments individual customers have
scheduled. Being able to set up recurring schedules would be helpful, too.
If it doesn't make sense to expand the calendar functionality, then create
functionality to synchronize customer list in RMS with Outlook.
This post is a suggestion for Microsoft, and Microsoft resp...Formula for changing Text Color??
I don't know if this is even possible. What I would like to do is t
input a number into a column in sheet 1 and have a correspondin
number (which is already there) change font color in sheet two. So
input a number, say 3 in C10 on sheet 1 and the number 3 which is i
sheet 2 (c10) changes from black to red.
Is this possible?
thanks very much
danh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1594
View this thread: http://www.excelforum.com/showthread.php?threadid=27420
You ...import fixed-length text file into excel
- 2 2299 Del Pietro M Wintervill NC 1:18:26 2:44:0
- 1 2045 Robert Marchinko M Salisbury NC 1:15:34 2:31:1
I have a text file where each field starts at same column and of th
same length in each record.
I tried cut&Paste,
I tried opening it in excel as a tab delimited file
I tried as a fixed-length file
None of these worked. Data came in scrambled or into scrunched columns
If the data were a table then cut&paste works great.
What's the secret in loading above 2 records into Excel? I couldn'
simulate the look ...CButton: Change size based upon text extent
I'd like to dynamically change the size of my CButton derived control based
upon the text/bitmap size. So if the application calls SetWindowText
during program flow the button rect will update.
What's the best way to capture this and override the rect size?
You can use SetWindowPos to change its size. You can handle WM_SETTEXT
and see what text is being set to, calculate the size of the button,
change its size and then call the base class handler.
"Ajay Kalra" <firstname.lastname@example.org> wrote in message
news:1145984489.865667.169280@e56...visio 2007 columns and relations disappeared
I reverse engineered a database and at some point the wile I was organizing
the tables a few of the foreign got left behind. I spent long time organizing
the tables and found this very frustrating. I could not find a way "reattach"
the tables to each other. I removed the orphaned lines from the page thinking
that when I updated the diagram from the database they would reappear. They
did not. In fact columns had also been removed from tables. How do I get the
tables to reflect the data in the database again? Refreshing the model does
...How do I format text as a bulleted item in Excel? Is it possible?
It's a manual effort.
You can use Insert|Symbol (if you're using xl2002+) or copy the bullet you want
from CharMap. (Windows start button|charmap).
You'll have to select that character in the formulabar and change the font to
what you want.
Chip Pearson has an addin that may help (if you're using xl2k or lower).
(look for Symbolizer and make sure you get the correct version)
Dave Peterson <petersod@verizonXSPAM.net> wrote in
http://...Create set based on column items feature in Pivot Tables 2010
I have a pivot table created in 2010 that I would like to use the
'create sets' feature in. However it is not enabled.
The three 'sets' features are disabled as are the OLAP tools / What if
analysis options on the Pivot Table options ribbon.
What am i missing???
Okay, found the problem - for 2010 the sets are only allowable for
OLAP based Pivot Tables.
On Nov 23, 10:16=A0am, jigsaw <jul...@consultant.com> wrote:
> I have a pivot table created in 2010 that I would like to use the
> 'create sets' feature in. =A0However it is not enabled....What are the zig zag lines under text?
I've got tiny black zig zag lines under my text. They're not spelling errors,
because spell check is completed. I can't view what the document layout
looks like because of these nasty little lines.
Word 2007, print layout view.
It indicates hidden text. If you toggle off the ShowAll command, the text
Terry Farrell - MSWord MVP
"Pamoola55" <Pamoola55@discussions.microsoft.com> wrote in message
> I've got tiny black zig zag lines under my text. They're not s...Need Help for Desirability Calculator (moving squares with numbers around)
I'm new to this forum and don't know much about excel. I want to make
desirability calculator wich is related to a game. In the game ther
are structures and each structure has a desirability affect on it
environment. When a few structures are placed next to each other it'
too tedious work to calculate their total affect.
I hope the attachment will be clear enough to show what I want to do.
There are around 30 structures but as an example I have shown th
desirability affect of two of them; an oracle and a garden. When yo
open the file you will see these two structures and thei...Importing Text file....need to manipulate text and spread across multiple columns.
I receive a number of different data files in varying formats. In orde
to effectively review the information, however, I need to format it an
sort it in a way that makes the data useful. Here is an example o
what I have (this infromation has been scrubbed) :
<Seam> First Name Neelakan Ready
<Seam> Last Name Chin
<Seam> Address 31 Bloomfield Lane,Apt #215
<Seam> City Auburn
<Seam> State Michigan
<Seam> Post Code 48336
<Seam> Country USA
Here is what I want:
USERID First Name Last Name Address City
<Seam>...extracting numbers from variable text
I am trying to extract a numeric value from a column of text that does
not always have any relevant data. Typical column entries are like
Employees: 46 | Employee Growth: -4.17%
Employees: 3336 | Employee Growth: -5.66%
Employees: 1700 | Employee Growth: %
but in this mixed bag of data there are many odd entries of free text
Two areas are using xx. Production studio's . . . . .
The data I want to extract is the number of employees, which can be
anything between a 1 and 6 digit number. I can do a basic extraction
using =MID(cellref, 12,6) to get the raw information, bu...Add one more EDGE in existing Exchange + EDGE 2007
I need to add new EDGE in my Exchange + EDGE 2007 enviroment (Edge in
LAN, I know that isn't a good choice, now I'm changing).
I need to deploy new antispam, so I want to Install new EDGE and test
it before I will go live, (this will be in DMZ) .
Some one could give me some macro information about this topic? or
...i want to swap text in one Word document?
I want to be able to use one document and insert two types of text, i.e., one
manual as Australian version and one manual as NZ version. Want to be able
to switch texts in the same document.
And your question is what?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Anita." <Anita.@discussions.microsoft.com> wrote in message
>I want to be able to use one document and insert two types of text, i.e.,
> manual as Australian ...Why are my excel worksheet columns are Numbered not Alpha
My excel worksheet columns are numbered not alpha. What did I do? How can I
change back to numbers
Tools | Options | General Tab | deselect 'R1C1 reference style | ok
"Paula" <Paula@discussions.microsoft.com> wrote in message
> My excel worksheet columns are numbered not alpha. What did I do? How can
> change back to numbers
You've probably set the R1C1 referencing style.
Go to Tools>Options> then selecet the General Tab and uncheck the R1C1...Prompt for the number of times to duplicate current record
I want to have a button on my form that will ask you how many times to copy
the current record and then copy that many times.
I cannot find anything on this. Can someone please help me?
Why? I'm not asking to be snoopy, but because a well-normalized relational
database may not need duplicate records.
Can you describe a bit more about the business need you feel this approach
(duplicate records) will help you solve?
Micosoft Office/Access MVP
"Krispy" <Krispy@discussions.microsoft.com> wrote in message
news:64453E77-E668-486C-8D98-09B98787C762@mi...Setting column width in printed reports
I print the same reports every week. Every week they are a different width
on the page. How do you set the column width to print the same width on the
page? How do you know if it is going to fit on the page?