HELP: extract certain characters from text string
How can I extract First letter from first name, remove the space between
first and last name and keep the last name?
I have a list of Names in this format:
and I want them like this:
Thanks in advance
Assuming A1 holds the text "John Doe". Fill down as many rows as
> How can I extract First letter from first name, remove the space
> first and last name and keep the last n...Please help, date problem with XSD file
I am getting the error:
Invalid character value for cast specification
In my xml file the date is like this:
Because of the field eventdate which is dt:datetime in my
******* MY XSD file
<?xml version="1.0" ?>
<ElementType name="eventdate" dt:type="DateTime"/>
<ElementType name="ReferenceNO" dt:type="var...Help to modify a formula
This is my formula I need help with,
in cell I10 this is entered
Problem is when cell I6 & I7 are blank cell I10 shows #value I need it to be
blank or 0
You should be getting zero when I6 and I7 are empty. It sounds as if there's a space or
something like that in the cell. Some folks do that to clear a cell.
Regards from Virginia Beach,
"Bob Bob" <NOeMAILl@mail.com> wrote in me...help with sorting 02-04-10
I have a very large spreadsheet of all of our cases. The headings correspond
to the following columns:
case # = column A, client # = B, last name = C, first name = D, Social
Security# = E, location # = F, case manager # = G, case type = H, additional
case identifier (not on all cases) = I, case status = J, and next review date
= K. The basic case types that we have are coded either "F", "M", or "A".
All clients should have an item for each heading (except for the additional
case identifier and Social Security#). So, for example, Joe Blow could hav...bsod, can anyone help?
Can anybody help me???
Problem Event Name: BlueScreen
OS Version: 6.0.6002.2.2.0.768.2
Locale ID: 2057
Files that help describe the problem (some files may no longer be
Extra information about the problem
OS Version: 6_0_6002
Service Pack: 2_0
Server information: c89648af-2b24-4c50-8cc8-a193033cb185
. CORRUPT_MODULELIST, C:\windows\minidump\mini010710-03.d
C:\Users\ELLIOTT\AppData\Local\Temp\WER-12969...SQL Help with Journals Please
Have a customer with 1.3 whose journals were huge and db had reached 2g
limit. To get them out of a hole I had to delete the journals completely as
it was stopping the pos's being used. Made a backup of the data first. I
didnt know the command to only delete before a certain date then.
They are now upgrading to 2.0 and I have the current db with about 2 weeks
journals and the old db with years of them.
I want to make the new db have the current journals and the previous years
from the db backup, can this be done via some sql commands?
> I want to make the n...Visio asking for Visual Basic for Applications.............................HELP!!! tia
My work laptop came with visio 2003 and when I try to merge an excel
table it is asking for the Visual Basic for Applications. Is this
something I can download some where? Thanx in advance.
I suspect that it is included in the trial version. CAVEAT becareful that
you don't over write
your production legal system with the trial software. I'd suggest you go
back to those that
loaded it onto your system. Another source is the VBA6.2 SDK which is
available for download
"Boll Weevil" <firstname.lastname@example.org> wrote in message
news:i30aa01k5fqegpg8rpt3ms5k0hgtthli2q@4...Need help with the SELECT statement. 12-11-09
I am converting Access db to SQL Server and need some help how to construct
to desire results below. Thank you in advance.
IF OBJECT_ID('Tempdb.dbo.#LoanComp', 'u') IS NOT NULL
DROP TABLE #LoanComp
CREATE TABLE #LoanComp
CompId INT NULL,
PurchPerf BIT NULL,
PurchNonPerf BIT NULL,
PurchRePerf BIT NULL,
PurchSemiPerf BIT NULL
INSERT INTO #LoanComp VALUES (8, 1, 0, 1, 1)
INSERT INTO #LoanComp VALUES (9, 1, 1, 0, 0)
INSERT INTO #LoanComp VALUES (11, 0, 0, 0, 0)
INSERT INTO #LoanComp ...urgent! Help please!
I finished a customization project for the client, everything works
fine in my computer. Then I use the setup and deployment project from
..Net to do the installation package. After installation, open pos,
click the custom button, it pop up with a message say
"Attempt to execute com object mydll.myClass failed. Could not Create
I searched through this group, made some change. ( I re-created new
project, set the class to be "COM class", according to someone's
suggestion, same problem) . In the project property, I have check the
"Register for COM Interop&...Help combining values with a space between
I am wondering if someone can help me with this one.
I have values in columns A and B.
The values are numeric.
I need to have the value combined into column C with a space between them.
A1 = 12345
B1 = 98
C1 must be 12345 98
>I am wondering if someone can help me with this one.
>I have values in columns A and B.
>The values are numeric.
>I need to have the value combined into column C with a space between them.
&g...Printing Help you are my last hope!
Hello. I'm a Direct Sales Contractor for local Cable company.
For years they have been providing my reports on BlueBar (some call i
Green Bar). I'd never seen the stuff (im young don't have muc
experience in the buisness environment).
I run about 5000 pages a month in reports, if not more. This didn'
bother me because the Cable Company covered the cost of printing an
As of last week, they've changed the way they give me the reports.
Instead of getting this report on BlueBar they've given it to me o
Legal paper which is smaller. They've fit all the inform...HELP with RPC over HTTPS
I have been trying to setup RPC over HTTP/HTTPS without any luck. This setup
is Server 2003, Exchange 2003 SP1 and Outlook 2003 with patch. I have
followed the recent documents from Microsoft support to the TEE. And still
when I try to connect from outside the network Outlook tells me the server
cannot be found do I want to work offline.
The one area of confusion I have is with setting the RPCProxy setting in the
registry. I am referring to setting this:
My question is about the FQDN. My FQDN is ser...Need help on Excel
I have made a program to keep up with my job cost and
Payout summary. I have that on Sheet 1, I am trying to add
things to sheet 2 for the total of the job record. Sheet
one in my main list to adding the cost and stuff for each
job. On sheet two, trying to make it work for total of
each jobs, which on sheet one I use to firgure my
supplies, invoice amount, wages and Profit for each job.
And my sheet two is for total of all jobs. So, I need help
on how to make it work for sheet one for each job and
sheet two for all the jobs. On each jobs I overwrite sheet
one for the next job and lik...outlook app crash HELP!
I keep getting the below error every time I open outlook...any suggestions?
Problem Event Name: APPCRASH
Application Name: OUTLOOK.EXE
Application Version: 12.0.6423.1000
Application Timestamp: 49b08185
Fault Module Name: olmapi32.dll
Fault Module Version: 12.0.6423.1000
Fault Module Timestamp: 49b08045
Exception Code: c0000005
Exception Offset: 000126cc
OS Version: 6.1.7600.2.0.0.768.3
Locale ID: 1033
Additional information about the problem:
This is the wrong forum for questio...a compile error,help.
//code above make error below.why?
error C2006: #include expected a filename, found 'identifier'
o_0 what the heck are you trying to do?
im guessing your trying to include a file if its not already been included?
"msg_du" <email@example.com> wrote in message
> #ifdef LABLE
> #include LABLE
> //code above make error below.why?
> error C2006: #include expected a filename, found ...Mouse Trouble Please help
Please help if you can!
I am going nuts with the following problem
windows xp, office 2000, excel, intellipoint mouse
I click on a cell.Then no matter what I do, the mouse
keeps selecting cells as if it were stuck. The cursor
stays as a cross.The keyboard seems disabled.
If I go to the file menu, it remains a cross, and I have
to control alt delete to end the program.
Please help if you can, I am unable to use the program!!
Try pressing the F8 key.
"Laurie" <firstname.lastname@example.org> wrote in message
news:6ce501c3e69b$3e469bc0$a5012...windows expplorer "search" is useless on my T43... help!
I have a T43 ThinkPad with Windows XP.
For years I have used Windows Explorer "Search" with good results.
Recently (or maybe not-so-recent) the search engine on it was "updated" to a
super-thingy that strives to search everything including file content.
Well, it has done that on RARE occasions, but only for limited things like
in specific directories, or something weird like
........documents\setting\admin... or the like where nothing of interest
When I try to force this thing ("windows\search\desktop") to search the
whole c:\ drive, it balks and s...I messed up and need help
I tried to change the folder that excell uses to another folder
and now when i open excell it cycles thru all my excell files
and opens them but withe different error msgs like
html import errors
problem came up in the folling areas during load
and no matter qwhen i click on "ok" or "cancel" it starts the recycl
again and i cannot get to any file.
then i get microsoft excel first pps file format is not valid
and file is not in recognizable format.
Can anybody explain how to get out of this and tell me how i can chang
the folder for excel to use
I need to limit the dates picked with the calendar to only 7 days before
today's date please help ?
You could use a Access form that works like a calendar and could make it do
what you need.
You could also use the after update event of the control that received the
date to do the validation.
>I need to limit the dates picked with the calendar to only 7 days before
>today's date please help ?
Message post..."Do...Loop" and data type adding help
private sub absent_click()
dim absentcell as range
dim row as integer
row = 61
if activecell.value = a then
row = row + 1
loop until activecell.value <> a
set absentcell = activecell
if activecell.value <> \"\" then
loop until activecell.value = \"\"
selection.pastespecial paste:=xlpastevalues, o...Network Adapter Name help.
Is there a way to get the Network name "Local Area Connection" beside
reading it from registry?
...PLEASE HELP: Outlook2003 Send Mail Error
Can anyone help me with this problem. Everytime I try to send out an email.
It gets rejected and I get this message:
The following recipient(s) could not be reached:
'email@example.com' on 5/5/2010 4:26 PM
554 5.2.1 554 AOL will not accept delivery of this message
> Can anyone help me with this problem. Everytime I try to send out an email.
> It gets rejected and I get this message:
> The following recipient(s) could not be reached:
> 'firstname.lastname@example.org' on 5/5/2010 4:26 PM
> 554 5.2.1 554 AOL will not accept delivery of...help with dividends & cap. gains
I've read thru Money's Help files but still need some clarification on the
exact process for entering dividends and capital gains received and then
automatically reinvested. It seems to me that in order to accurately record
these transactions I need to enter two transactions for each distribution:
one that records the receipt and a second that records the reinvestment. Is
The two transaction approach uses these investment activities:
Dividends Received / Buy
L Term Cap Gains Received / Buy
S Term Cap Gains Received / Buy
The following investment activities work as...Help! Keep formulas from updating refs when copied??
This is getting frustrating! I've got a series of summary tables on one
page. Each table is taking data from the exact same locations on other
sheets (that is, one table will use Sheet1!B3, and the next table
Sheet2!B3). But each time I try to copy the summary table down the page,
hoping to simply change Sheet1! to Sheet2!, the B3 reference will
automatically update the number of rows I've copied down, and B3 is now B7!
I tried Copy>>Paste Special (Formulas), but I keep getting the same update
frustration! Any help?
This is where you use the function key F4 or manually...Help, my browser has been hijacked!
I am running Internet Explorer 7 (7.0.5730.13) under Windows XP Service Pack
Recently, when I do a search from Google or Yahoo, I get back the expected
listing of hits. For example, I did a search on "Internet Explorer Beta 2".
I got a page full of references, one of which was a link to the Windows
Internet Explorer 8 Home Page at
www.microsoft.com/windows/internet-explorer/beta. When I click on this link,
a new page opens with the following in the address bar: