Parse only text from column?
How do I extract just the text from a column? For example, if one of my
columns = "1234 abracadabra" and I want just the "abracadabra"?
You already posted this question about 3+ hours ago and that message has 4
answers posted to it.
Rick (MVP - Excel)
"Ryan D" <RyanD@discussions.microsoft.com> wrote in message
> How do I extract just the text from a column? For example, if one of my
> columns = "1234 abracadabra" and I want just the "abracad...How to define a style to include built-in text?
I need a style that has its own text. For example, Caution_Head would say
"Caution" without my having to type it. I don't see where this is entered in
the style dialog. Thanks for any tips.
Lockheed Martin, Eagan MN
Message posted via OfficeKB.com
The only way to do this is as a "bullet." See
http://sbarnhill.mvps.org/WordFAQs/QandA.htm (Word 2003 and earlier) or
http://sbarnhill.mvps.org/WordFAQs/QandA2007.htm, as appropriate.
Suzanne S. Barnhill
Micros...Why is Actual Work updated when entering time into Work Field?
We're using MS Project 2007 and seeing that sometimes when time is entered
into the Work field for a task, that task's Actual Work is updated to the
same value entered in the Work field. This happens to multiple resources,
but only on some of their tasks and not on others. For example, for the
weeks of 1/24 and 1/31, whatever hours I schedule (enter in the "work" cell
in the Resource Usage View) for a given task also appears in the "actual"
The tasks are setup up differently. Some are Fixed Work, some are Fixed
Duration. I believe all have the e...Row Height Adds Blank Space at End of Text
We have a spreadsheet where the row height is automatically expanded to add
extra, blank space at the end of the cells. We manually adjust the row
height, save, close, and when we re-open, the space is back. There are no
extraneous returns in the cells. Anyone know how to fix this? Auto Fit does
not work. Thanks
...Excel 2003 spreadsheet. I enter the any number and it is entered.
If I enter a number into a cell it is put in like a decimal. For example, if
I enter 10 it is put in as .1 500 is entered as a 5
Goto Tools>Options and on the Edit tab you should see The Fixed Decimal
Places box checked. Uncheck it.
"maryu" <email@example.com> wrote in message
> If I enter a number into a cell it is put in like a decimal. For example,
> I enter 10 it is put in as .1 500 is entered as a 5
> Thank you
...Filter records by date in subform by date entered in mainform.
Hello, I've spent 3 days trying to understand what I'm doing
wrong.....Here is the summary of my problem.
I have a form named 'frm_EfficiencyStats' and a subform within the
form named 'qry_Total hours subform' (the subform is based on a
query). The form contains a text box (for date) which is bound to a
I would like to be able to enter a date in the text box on my form,
and display the records in the subform based on the date I entered in
the text box. The subform will only pull records from my table based
on the date.
Here are th...Copy only part of text string
Wonder if someone maybe able to help me please.
I have a database at work that contains details of test files. One of the
fields for each test shows that actual error that caused the file to fail.
The problem is, is that there is an awful lot of text from this field that I
don't need to extract.
The text I need to extract starts with the word Error and then the rest of
the text that comes after it in the text string. The word Error can appear
anywhere within the text string, but having worked through all of the
failures I beleive that 'Error' can be used as the guide to star...Signature and text format query
I have created a signature which inserts automatically when I click New,
Reply or Forward in Outlook.
But when right clicking a file and selecting Send To, Mail Recipient it
opens a new untitled message in Plain Text with a signature/footnote ("The
message is ready to be sent...). How can I have that message open up in HTML
Also, how can I set it up so that my own signature that I have created
automatically appears when the untitled message opens up (instead of having
to insert it manually afterwards)?
The same question applies when I have an open file (eg: ...Shortcut for wrap text or vertical center in cell
Is there a keyboard shortcut for wrap text? how about centering data
vertically in a cell?
Have you considered assigning a short macro to the KB combination of i.e.
> Is there a keyboard shortcut for wrap text? how about centering data
> vertically in a cell?
Looking in Help for formatting shorcuts yielded nothing. You can roll your
own, using the underlines. For wrap text, it's a bit long. Alt-o, e, a,
Alt-w, Enter. For vertical centering, Alt-o, e, a, Alt-V, c, Enter.
Or you could record a ma...how to enter simple list and sum
using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?
if the list would look like this
the output would look something like
In B1 enter =A1
In B2 enter =B1+A2
Copy down to B5
Gord Dibben MS Excel MVP
On Wed, 16 May 2007 06:34:13 +0300, "John" <firstname.lastname@example.org> wrote:
>using excel 2002 with an xp sp2 system
>how would I enter a simple list of positive and negative...Resource Units for Tasks entered in PWA differs than tasks entered in Project 2007
I have an ePM user asking why if he enters a project task in PWA does
it not check the resource max units allocation the same way as when he
enters a task in Project Professional.
You have a project where resource A is 50% allocated. When you create
a task in Project Professional for this resource, the resource
allocation is set to 50%.
Create a task under the same project in PWA, submit and approve the
Open project professional and view the task information for the task
entered in PWA, why is the resource allocation set to 100% instead of
50% set for th...IF Function with Text values
Hi, I can't seem to get the IF formula to work with my spreadsheet. I have
two colums one with user login the other with surname and i need to pick the
surname out of the user login and i can't get the IF true or false to pick
out the surnames, any help very much appriciated.
use something like
> Hi, I can't seem to get the IF formula to work with my spreadsheet. I
> have two colums one with user login the other with surname and i need
> to pick the surname out of the u...Resizing row height to dynamically fit height of text box
Is there a way to link the height of a text box to the height of a row so
that as you type text into the text box and the text box's height increases,
the row height will also increase?
I know That by setting the "Move and size with cells" option you can make
the TEXT BOX height increase as the ROW height increases, but I'm looking to
do the opposite (i.e. make the ROW height increase as the TEXT BOX height
Not too complicate things too much, but I was also hoping to do this within a
> Is there a way to link the...Wrap text and row autofit
If Wrap text is enabled for a cell, the row autofit function works properly.
But if I merge 2 or more cells in a row, then autofit doesn't work. It sets
itself to the height of 1 row even if the contents require more than 1 row's
Note: Excel 2003 version.
Rows with Merged cells will not Autofit. Just one of many problems with merged
You need VBA code to do that.
Here is code from Greg Wilson.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As ...Enter formula by code.
can anyone help. I cant seem to get this to work.
I keep getting run time error 1004
application or object defined error.
Public Sub TLIdentify()
finalrow = Worksheets("INV Bookings").Range("B65536").End(xlUp).Row
Worksheets("INV Bookings").Range("AV26:AV" & finalrow).FormulaR1C1 =
Regards and Thanks for any assistance.
Francis Brown...Conditional Formatting Text!!
I want to conditionally format some text in a spreadsheet using
I have column A1 with:
What I want to do is for all cells which contain "5a Be" "5b Be" 5c
Be" "4a Be" "4b be" and "4c Be" to be highlighted in Red - is there a
formula to put all of them into one formula - If("5a Be" or "5b Be)
"Kiran" <email@example.com> wrote in message
...how do I copy several lines of word text into one excel cell?
In a word doc I need to copy several lines of text and paste them into one
excel cell. I can't seem to find any help telling me how to do this (each
line pastes into a different cell)
You can either double click the cell or press F2 key to get into edit mode
for the cell, then the text pasted would all go into the cell.
> In a word doc I need to copy several lines of text and paste them into one
> excel cell. I can't seem to find any help telling me how to do this (each
> line pastes into a different cell)
thank you SO much Simon CC - ...Entering a dollar amount w/out having to enter the decimal
What is the formula to have Excel automatically enter the decimal so all I
have to enter is the numbers?
It's one of the options you can specify. In Excel 2007, it's:
Excel Options...>Advanced>Automatically insert a decimal point
"Julieanne" <Julieanne@discussions.microsoft.com> wrote in message
> What is the formula to have Excel automatically enter the decimal so all I
> have to enter is the numbers?
...Word Wrapping Text
Applied word wrap to data within cell; word wrap only
applied to portion of data within cell. When viewing in
print preview only a portion of the text is displayed.
Thank you in advance.
You didn't whether it didn't fit the column or the row. Try re-formatting
the cell -
Print preview doesn't always show everything. Regard this as a thumbnail
view rather than an actual representation of the page to be printed.
"Sonya" <firstname.lastname@example.org...How do I stop dates from being entered everytime I enter a number
Everytime I enter data in a box (ex: ages 5-9) I then press enter to go to
the next cell and it automatically puts in may 9 . I have tried putting in
general in formatting cells and it still does it. can someone help before I
shoot this pc out the window? I am making a population pyramid with males
and females and their ages.
Kicking and Screaming
You can precede your entry with a single quote...
....or format your cells as 'Text'.
Hope this helps!
In article <64AE5219-035D-46E3-9488-5D01F6B012FA@microsoft.com>,
Kicking and Screaming <Kicking and...Shared calendar does not show text in appointments
I've had a request for help because a user on our network, who has access
permission to her bosses calendar, has a problem. When the PA sets new
appointments she can see botht he new item and all the other appointments,
whether she set them up or her boss did.
However, when the Boss looks in the calender for herself, the ones set up by
the PA show as blank spaces, but the subject line does not show the text.
The PA knows how wto do this and IS using the subject line properly to
detail what the appointment is for.
Honestly, I'm baffled - I've never heard of this before. Any ideas ...Formula showing in cell as text
This is a new one on me. After entering a formula, instead of seeing
blank cell or the result of the formula in the cell, I'm seeing th
text of the formula as I normally would see it displayed in the formul
bar. I can't seem to get it to calculate or stop showing the formula a
text in the cell.
One additional odd thing, going to TOOLS>FORMULA AUDITING>EVALUAT
FORMULA, everything looks normal, with two exceptions; one a statemen
"The cell currently being evaluated contains a constant", is displaye
in the dialog box and all but the CLOSE button are grayed out.
What I ha...Changing text on convert lead webpage dialog
In the Opportunity form, I have renamed the "Potential Customer" Attribute to
But on the Convert Lead webpage dialog, under Opportunity - the lookup field
still displays as "potential customer".
Is there anyway of changing this text?
I think this webpage dialog is not customizable using the standard tools. I
remember having a customer wanting to add functionality to the convert lead
webpage. If someone has an idea about this would be nice.
Merijn van Mourik
> In the Opportunity form, I have ...entering time #2
wondering if there is any way to do this...
I have a column formatted for time as in this format 12:00
when entering a time it is cumbersome to have to enter the hour, then a
colon, then the minutes.
Is it possilbe to simply enter a 4 digit number such as 1245 and have it
show up as 12:45 ??
thanks so much... I've found this group to be irreplaceable...
glen in orlando
Enter your times without colons in column A and put this formula in column B
and format column B for "Time" in the form you want it.
"Glen i...Entering data
Please help me enter data into cells that seem to be
In article <email@example.com>,
"Alicia Contreras" <firstname.lastname@example.org> wrote:
> Please help me enter data into cells that seem to be
Tools > Protect > Unprotect
Hope this helps!