You need a macro to rearrange the name. Excel makes it easier to extract first or last names. nm

• Easier way to sort an address list in MSWord? - probono
  • sorting addresses - Polish girl
  • Is each address on a separate line? And do you have Excel? - sj
    • Not on a separate line, per se - probono
      • You can highlight the entire list and use the convert text to table option in Word. You can highligh - table option. sm Cheri
        • Spiffy! - probono
          • You need a macro to rearrange the name. Excel makes it easier to extract first or last names. nm - Cheri
        • Oops, I don't know what I did to get that twice, but - sm Cheri
    • Yes, I have Excel - probono

The messages you are viewing are archived/old.
To view latest messages and participate in discussions, select the boards given in left menu

I wonder if that would be of the same benefit...just off for a few months because of money reasons!  any health food store carries it, but, of course, you want a good one. 

also, evening oil of primrose is great, still taking that because there was a sale on it...love it.

I know a little bit about Excel, but not a whole lot. I'm trying to learn from books and through trial and error, but it's slow going.

So here's what I want to do:  I need to set up a spreadsheet so I can record date, exam number, number of characters, divide number of characters by 65 to get number of lines, multiply lines by 10 cents to get amount for each report.

I know how to set up individual cells to divide or multiple, but how do I set them up for the entire spreadsheet, or at least within a range of, say, 100 cells/rows?

TIA!

If I am reading you correctly and if not sorry --but if you do not need every report divided but the entire month or a section of the spreadsheet -- what I do is I enter the lines and at the bottom I have a total of B1.B65 (sum=(B1:B65) then the next cell I have it * my cpl (I have gross lines) but if you are doing 65 cpl, then you would put in your total characters, the spread sheet would total on line B66 and then B67 you write formula to divide sum=(B66/65)by 65 and then B68 would be  sum=(B67* cpl).   I enter daily line counts by doctors and have then total vertically and horizontally so I get totals by doctor and by day and then month total.  This probably sounds very confusing but you can E-mail me if you have specific questions.    Patti

on my laptop (not the work computer) with 2 different spreadsheets for each account.  I list dictator-specific shortcuts and notes on one, and general account specifics on the other.  I also have one spreadsheet in the workbook for "terms"...with multiple columns for different categories (derm products, lab nomenclature, vaccination drugs, etc.)  Finally, I have a worksheet for "blanks" with specific but common quotes from dictators and the correctly typed translation. 

I am up to about a dozen spreadsheets in this one workbook file, but it is quick and easy to bring up the one I need and keep it in front of me as I move from client to client.  Good luck. 

inhouse experience was awful.  Not only was I transcribing for $15 an hour, I had to make copies and go down 2 flights and stuff their mailboxes with copies.

I so much prefer working at home of a national, where all I do is transcribe, and they take care of the distribution of the records.  I just push send.  Plus I find the dictators a lot more doable than at that hospital.  They were a mess.  They didn't even have a standard format.  It was just, whatever.

My youngest sister came by this late night after getting off work.  She works 2nd shift at a local factory.  It has provided an okay and steady living for her and her family but it has taken its toll on her.

Her beautiful young face is worn and tired.  Her clothes are nasty from the oil and sweat and metal shavings.  Her poor little hands are literally worn out, muscular, rough with callus.  Her back hurts all the time from all the standing.  Some of the attitudes she works with keep her humble little soul in discomfort. 

She gets in trouble by management and by every line worker if she has to miss.  She has no opportunity to move anywhere really within that plant.

We don't always have the work we want in this business and sometimes we have to really take a stand to get where we need to be.  All said and done, though, we have it easy. 

I don't have to wear my self out physically.  I can get up and stretch and take a break.  I can be somewhat flexible with my time.  I don't have to put up with people who try to control or intimidate me.  I have a marketable skill, though that market is changing rapidly ... it is still a skill that I can adapt and use.  There are so many ads on this very board that I can explore if I need a change or additional employment ... all those opportunities and I don't have to move anywhere, I don't have to uproot my life .. just go to work for someone else.

We have it easier than we think. 

I have found that many transcriptions who say they want to work for me have one of three issues:

1. They embellish on their experience/quality.

2. Time off--they want more time off than I get and they usually wait until they're walking out the door to say they're not available. Deadlines are seen a "negotiable".

3. They are asking for more per line than I am able to pay (usually they want .12-.14/line--I only charge .12/line on my accounts because that's all the market will bear)

Many of these are newcomers to the field who have somewhere gotten the idea that they can get away with all of these behaviors. (I would bet more than one of them are some of the criers on these boards as well.)

I would LOVE to find someone who is dependable and experienced, who knows how to work and is not looking to take my accounts on a permanent basis; someone who would do as good a job for me as they would want someone else to do for them if they needed some time off. Apparently, they're all working for other companies and are happy, which is great for them.

1.         Open a blank document.

2.         Type 3-4 question marks down in a single line.

3.         Put your cursor back up at the top before the first ? mark.

4.         Open tools Macros – Record new macro.

5.         Click keyboard – type in the combination of keys you want to use to jump (make sure that combination is not assigned to anything else).  I used Shift+Control+Alt J.  Then close that box out.

6.         With your mouse click Edit - Find – type a ? in the find box, click Find Next.  It will take your cursor to the first question mark (make sure it’s highlighted).  Then hit cancel to close out the find box, and click STOP on the macro button.

can someone please tell me how to make a macro in word for go to *?

Can anyone give me instructions on how to create a period macro in word 2003.  I want to make a macro that inserts a period when I need it.  I use ASR, so I need this function to make corrections easier.

Thanks so much!!!!!

To work a split shift, example 6-10 n then 3-7, OR would it be less painful to get it all done at once so you have more time to rest fully?  My hands kill me constantly.  I've tried everything.  Don't want to be in more pain if the split would end up being worse.  Thanks.

I love ASR (automated speech recognition) aka editing as it's easier on the hands for some (me!!).  It does pay 20% less per line but I'm very fast with editing.  I like it a lot but to each his/her own opinion on it.

Good luck!!

I'm using Word 2003 with Instant Text as my Expander software.  I have been trying to figure out how to insert *stop codes* literally for months using Instant Text.  I finally gave up and here's what I do.  There may be easier ways around it, but I just learned today. lol

I transcribed the report,, which is a pain center report. I get the same doc everyday who has a style that he sticks with pretty much.  After I was finished, I copied the report and went into a new document to tweak it up.  I left in basically all of his  repetitive phrases along with the exam, and all of the headings.  Anywhere I wanted a stop code or field as MS Word calls it, I pressed the combination of ctrl+ F9.  When I  was  finished I highlighted the document and clicked on Autotext.  If you've never used autotext, when you want to retrieve an entry you've created, you start typing the name you've assigned to it, and either press F3 or enter and BAMM there it is.  The stop/field codes look like this {  }, but you can shade them gray.  To access each field you simply press F11 and it takes you right to the next stop. I hope I didn't confuse you.

I just bought a book that is truly a MUST HAVE for MTs working with Word.  It's called Tips N Techniques to boost the productivity of the medical transcriptionist.  It was put together by an MT.  I think you can find it under www.cherylflanders.com.

Good luck!

Rin