Highline Excel Class 26: Fixing Other Peoples Spreadsheets

Good Morning,

I have numerous excel spreadsheets that colleagues complete with data including a persons name.
They all seem to have different ways of entering a persons name into the appropriate column.

Some use copy & paste from another database to get
Mrs A N Other

Some will Type directly into the cell any of the following formats

Mrs AN Other
Mrs A N Other
A N Other, Mrs
Other, AN Mrs
Other AN Mrs
Other, A N
Other A N
Other, AN
Other AN

Is there a way I can get a formula to look at each cell and pull out just the Surname & Initials and format into

Other AN

I have tried using Trim to get rid of spaces along with edit & replace to get rid of all the ,'s between. There does not seem to be anything in the varying formats that can be used as a tag to start from.

If this is too complicated is there away using Data Validation to restrict the way they enter data into the cells, I know that Copy & Paste will overwrite the data validation but it will help for most of my colleagues.

Thanking you all in advance

Ray

Hello!
My name is Larisa :-)
My homepage - http://www.goldenrings.eu/

I very like to speak with interesting peoples :-)

I study and take care of myself now. I was fifteen when I became model. I advertised clothes, traveled to many countries and was shot by different photographers...
On my site you may see my fotos...

i get names downloaded into my spreadsheet, as an example;


miller, richard
john hayes
jane burton
Santowski, ron

some are in reverse order, always with a comma in between the names, and the others are perfect in the right order, with of course no comma.... How can i write the formula to check to see if in reverse order, and if so, switch the names in the right order. Also, if in perfect order already, simply leave it alone. I keep getting errors in my formulas and cant solve it. Thank you.

Below is a picture of a weekly timesheet for 3 employees:



Is there a way to just print specific blocks of names in the list?

Do I need to highlight then some how print? pick from a list? The names are not always going to be the same or in the same order, so wha twould be the easiest way to pick the 7 rows that go with the name and have them print? In the sample given, I may want to print the first and third person listed, then print the 2nd and 4th person listed.

Let me know if I am not clear on this and I will try to explain further.

Thank you,
Michael

I have made some user defined functions and want to share those with other colleagues in my office.

What is the way to send these functions so that they can run from their machines and also how can I hide the code so that they don't mess the code.

Thnx

I have some billing in Microsoft Works spreadsheets on my home computer --
now I have a new job and I want to do billing at home, but my new job uses
Microsoft Excel. How can I use the Excel spreadsheets on my home computer.
Do I need to buy the program?

If I have one value I need fixed, which key on the keyboard do I hit after I enter the value?

Hi-

I've been keeping some data in a spreadsheet since since July. I made an accompanying chart -- not that I know what I'm doing, I just kept at it until I had what I wanted.

Recently I extended the data range. It got my chart all wonky. I was able to straighten out most of the screwy stuff but two big problems remain and I haven't been able to find any solutions via the MS Help menu. ...possibly because I don't even know how to ask the questions correctly.

One prob is that one set of results just comes to a premature halt on my chart even tho there is ongoing data on the spreadsheet. None of the other results have done that. I'm not sure if it could be because I color coded the background in the spreadsheet and there was a one week interval where I changed the background color. The reason I'm not sure if there's a correlation is because of the second problem. In any case eliminating the color change didn't correct the problem.

Prob two is that, for some reason I can't understand, the legend for the date on the X axis went from beginning in July to beginning in January. As a result, I can't be certain that the cessation of results (see above) dates from the time I changed the color background.

I'd also like to color the background of just a target area on the chart. Is that possible?

Thanks in advance. I'm using a Mac with system 10.4.11. My Office version is 2004 and it updated itself within the last 14 days. Thanks again.

Hello guys,
I am converting an excel sheet to a pdf and have some slight problems:
1.) It only pdfs the first sheet in my workbook (i think it actually did pdf more than one sheet but I do not know how to write the code to make it always pdf the entire workbook, the first sheet should also be in portrait and the second sheet(s) in landscape).

2.) It asks to save twice and sometimes does not save as the correct name (it will have a blank in the 'save as' space)

If you can help what is the best way to have this code written? Should I get another pdf creator? (I can easily get pdf factory on this computer, if the code will run smoother?)

Also this computer is using excel version 2003

Code:

    Application.ActivePrinter = "CutePDF Writer on CPW2:"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
        "CutePDF Writer on CPW2:", Collate:=True

ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF:", Collate:=True
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 2
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
Filename = "X:\Logbook\PES Receipt"
SendKeys Filename & "{ENTER}", False

Sorry if this has been dealt with, i couldn't find the answer i need.

I have a spreadsheet with 6,000 rows of dates. There are two date formats in these rows, and to sort and filter i need them to be homogenous.
Example:

Travel Date 280108 250208 90308 170208 170308 190508 190508 50508 110808 110808

I can convert the 6 digit dates easy enough, but does anyone know how I can fix the 5 digit dates so that they display as 6 digits? The date format should be DD/MM/YY for all.

Thanks