Help with seperating data?
Hello I was wondering if anyone knows a way of seperating chunks of data
into specific lines. i.e:
href="3353-12American Baby href="1721-6American Cheerleader
href="10a8-12American City & County href="2928-24American Conservative
href="1072-6American Cowboy href="6035-6American Handgunner
href="3343-6American Heritage href="2498-4American Heritage of
Invention & Technology
href="10a8-12American City & County
href="2928-24American Conse...Masking the sent from field with a seperate domain?
We have Exchange 2k3 and AD setup. We use the pop3 connector to download
email from various seperately hosted domains and route the email to the
correct client. Our users have noticed that any email they send shows the
recipient the local domain in the sent from field. We need to mask it to
say that it come from a different domain... for example one of the domains
that we use to download email from using the pop3 connector. Is this
possible? Any help would be greatly appreciated.
> We have Exchange 2k3 and AD setup. We use the pop3 connector to
I hope that someone can help?
I have been sent a work book where several columns have data seperations
between words as follows:
The data appears to have a square box in between the "UK" and the "Pounds"
Please can you advise a quick way to change the format in all columns in the
Saved from a previous post:
Chip Pearson has a very nice addin that will help determine what that
Since you do see a box, then you can either fix it via a helper cell or a macro:
=substitute(a...Random Number Generator #2
I need to create a random number generator in Excel 2000 to fill one column
and about 3000 rows. How do I go about doing this?
To generate a random whole number between 1 and 3000, you can use
> I need to create a random number generator in Excel 2000 to fill on
> and about 3000 rows. How do I go about doing this
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1101
View this thread: http://www.excelforum.co...Plain Text Direction
I have purchased Notebook with Vista from Dubai. My language set is as
English and Keyboard US ( Vista Home Regional Langague setting ). In office
2007, I have set langague as ENGLISH USA.
In microsoft Outlook 2007, I am expereincing unique problem.
All incoming mails in PLAIN TEXT which include emails, read receipt and
delivery reports are appearing in Right to Left Direction. Repeat in PLAIN
There is no problem in HTML and Rich Text Messages.
I want to set text direction as LEFT TO RIGHT as defualt for PLAIN TEXT
In Option, I could not find tab for LEFT TO RI...How to Print PO Number and Check Number to GL Trial Balance Detail
Can anyone help me to print the PO Number from Purchase Order Entry and
Check Number from Payables transaction Entry to GL Trial Balance Detail
report. I've searched some knowledgebase but it doesn't work. can you make me
that report or can you give me step by step procedure on how to print po
number and check number. The code i've already check are listed below: Note:
it doesn't work!
Pls hope for your response
You should insert the orginating document number from the Year to Date Table
this ...have 3 pieces of data in a cell seperated by a comma. How can I isolate the middle piece of data?
I've imported a large file of data that is basically three columns of data each seperated by a comma. (I could not figure out how to import them into a new spreadsheet so that each piece of data was automatically put into it's own column - but that is a different question)
How can I do a "search replace" that will delete all of the data up to the firts comma?
Then I would want to delete the data after the second comma in order to isolate the middle portion of data?
Here is an example of the data: "10302003-12445","17.99","xyz21"
Is there a be...display number as number name
I want to get the number name of the corresponding number i enter.
"Kamala Kannan" wrote:
> I want to get the number name of the corresponding number i enter.
...formula to BOLD partial number
MY experience with your group is awesome. Can you help me with this one,
I have time data "06:09:23" is there a formula where I can indicate the
first two caracters ("06") to be bold. Manually to do this could be quite a
hassle for a couple of hundred cells.
One simple way
For Each c In Selection
c.Characters(1, 2).Font.Bold = True
Microsoft MVP Excel
"israel" <email@example.com> wrote in message
news:1C76F7C5-01F4-4033-8...Seperate words in a field
I have data that has information in a field that I need to separate.
Example: Jimmy Ray (2004) (director) (producer)
Jenny Rich (2000) (Actress)
From this example I need to separate the items in parentheses from the name
and enter them all in different columns. Is there a query or other possible
way to do this?
Thanks for any help given.
As I see it this would be a 2-step process.. First you would separate all
Divide text across cells
Select the range of cells that contains the text values. The range can be
any number of rows tall, but no more than one...text : Frequency
I need to know how many time I have a stringA
StringB and a StringC in a column. I think frequency
is only for numbers. How can I do it with Strings?
So With the frequecies of each 3 strings,I will be
able to build a flowchart.
For example: =COUNTIF(A1:A200,B1) for a range in column A; adjust to
or: =COUNTIF(A:A,B1) for all of column A
"Jack" <firstname.lastname@example.org> wrote in message
> I nee...Default Text
How can I change the text default from "plain text"
to "HTML"? I know it is probably easy, but I can't find
the option anywhere. Any help is welcome.
You don't say what version of Outlook you are using, but in 2003 (and XP, if
I remember correctly), at the Inbox menu, select Tools, Options, Mail
"Nancy" <email@example.com> wrote in message
> How can I change the text default from "plain text"
> to "HTML"? I know i...Serial Number
I need to delet hundereds of old sold serial number. Is there way I can get
script ? All the serials are under one item.
Harjit SherGill /DBA
324 South Main st po box 370
Altaville CA 95221
Tel : 209-729-1410
Hi Gill - Of the serial numbers you need to delete, how many line items are
they attached to (i.e. hundreds of serial numbers under 1 item, 2 items, or
There are some easy scripts to remove these, but it will all depend on:
1) What side is deleting (HQ or SO)?
1a) If HQ - will you also delete from SO?
2) Are the serial...How do I move text to beside (rather than after) a photo?
I have MS Word 2007.
When I place a photo or text box onto a page, I can't then get text to enter
beside it. The cursor will only go to the side just above or below the
How do I enter text alongside the picture?
Change the text wrapping on the photo or text box to Square.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Mrs Mainster" <Mrs Mainster@discussions.microsoft.com> wrote in message
>I have MS Word 2007.
> When...Delete an unused check number
Is there a way to delete an unused check number not entered into the system?
We used a check for a manual payment, but ended up voiding the check as it
was not needed. Since the check was never printed, this check number does not
appear in the system so I can't void it. But the physical check itself is
obviously not usable now. Thanks for any help.
The only thing I can think of is entering a manual payment for $0 to use up
this check number.
Dynamics GP MVP
Flexible Solutions, Inc.
"melissa" <firstname.lastname@example.org> wrote in ...How to draw a vertical text properly?
Could you give me a favor? How to draw a text vertically and make it looks
good? I was trying to change a lfEscapement of LOGFONT, but then it looks
sharp. lfQuality flag doesn't make a sense.
...Repeat row numbers
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27,
etc to the end. I'd rather not copy and paste!
Put 1 in a1, and this formula in A2, and copy down:
"Carole O" <CaroleO@discussions.microsoft.com> wrote in message
> Excel 2003
> I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 -
> etc to the end. I'd rather not copy and paste!
> Carole O...Do not count minus-numbers
I have some number I would like to SUM, but I dont want excel to
calculate the minus-number.
Here is what I have -
I do it like this SUM(A1:G1)
But I want it to say SUM(10+20+30+40+0+0)
How can I do it like that ?
"SpookiePower" <email@example.com> wrote in message
>I have some number I would like to SUM, but I dont want excel to
> calculate the minus-number.
> Here is what I have -
> A1 10
...using text box as query criteria
I have a form with a subform. My main form has a text box wich is used in
the query expression of my subform.
In the KeyUp event of the text box I refresh the forms.
This works to filter my subform each time a new character is entered into
the text box.
My problem is every time a key is pressed the refresh selects the entire
contents of the text box.
each new letter you type replaces the last making it impossible to type an
Is there and easy work around. Is there a way to mimic the end key behavior
On Fri, 23 Feb 2007 16:11:05 -0800, "Tim ...macro based on text or number
I want to do an if statement within a macro that will copy and paste to
another cell, a field that is text. Anything numerical should be skipped. How
do I do this?
Here is one way.
Set rng = Sheets("Sheet1).Range("A1")
If Not IsNumeric(rng) Then
"JOSEPH WEBER" <JOSEPHWEBER@discussions.microsoft.com> wrote in message
>I want to do an if statement within a macro that will copy and paste to
> another cell, a field...How to HR user to modify GAL user phone number and address details.
I need to allow a HR user to modify GAL user phone number and address
What is the cleanest way to allow these permissions only?
Exchange 2003, outlook 2003
Quest Active Roles Server
<firstname.lastname@example.org> wrote in message
> I need to allow a HR user to modify GAL user phone number and address
> What is the cleanest way to allow these permissions only?
> Exchange 2003, outlook 2003
**I need to allow a HR user to modify the GAL through Outlook 2003
cant i just delega...Master Transaction Number & Trx Source Number
In SOP what this numbers mean
Master Transaction Number
Trx Source Number
What is the initial tables for this number.
Thanks a lot.
This really is a developer question that may be better posted/answered on
the mbspartner.developer ng. That is for GP and SBF developer questions.
"Vitali V" <email@example.com> wrote in message
> In SOP what this numbers mean
> Master Transaction Number
> Trx Source Number
> What is the initial tables for this number.
> Thanks a lot.
Tha...Running Total of Random Number
Hi, I am trying to create a probablity simulation for a high school lesson.
It involves rolling 1/2 dice using the randbetween function to create the
I want to keep a running total of the outcomes 1-6 in a cell for each which
is linked to a chart.
Is this possible?
Do you mean a running total of all the values from the dice, if so do
tools>options>calculation and check iteration and change from 100 to 1,
assume randbetween formula is in A1 and you want the running total in B1,
in B1 put =A1+B1, press F9 to calculate
"Mr H" wrote:
&...Adding a Mobile Phone Number field to a Case View
Is it possible to add the customers mobile phone number field to a Case View ?
have you tried adding the attribute to the entity?
"Marc Harrington" wrote:
> Is it possible to add the customers mobile phone number field to a Case View ?
> Marc Harrington
Thanks for the reply Ian
We tried adding a mobile phone attribute to the case entity with no success.
There is a system relationship between the case and contact entities but we
cannot create a relationship between the case entity and the conta...transposing numbers.
I wonder if anyone can help.
I have a list of numbers that are sorted in numerical
order. I typed them from up to botom. I would like to
display them horizontally instead.
For example, they look like this:
I would like them to look like this:
1 2 3 4 5
Can someone help?
Thanks in advance
"Rimma" <firstname.lastname@example.org> wrote in message
> I wonder if anyone can help.
> I have a list of numbers that are sorted in numerical
> order. I typed them from up to botom. I would like to