How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Zabo04 Your Own Question

Zabo04
Zabo04, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 211
Experience:  Experienced in Word, Excel, Access, Powerpoint, and Outlook.
58597962
Type Your Microsoft Office Question Here...
Zabo04 is online now
A new question is answered every 9 seconds

I need your help separating my document into separate fields

Resolved Question:

I need your help separating my document into separate fields in Excel.
Caller: Dr. James
Reason: admission
XXX-XXX-XXXX
From:Bergan Mercy Medical Center
Omaha,NE
CHS Doctor:RAMEY XXX-XXX-XXXX
Paged: 9/8/2013 2:45:50 AM
Connected Caller: 9/8/2013 2:47:07 AM

Agent:sml
Acct #: Hospitalist
Submitted: 11 months ago.
Category: Microsoft Office
Expert:  Zabo04 replied 11 months ago.

Zabo04 :

Can you attach the document to this question? You can use the paperclip to attach the document, even though it says image only. If you have sensitive information, save a copy with two lines of sample (aka fake) data in the same format and I'll work with that to produce a pdf with instructions for you.

Customer:

Attachment: 2013-10-13_235938_test1.xlsx

Full Size Image

Here it is! I want to be able to replicate what you do in future reports.

Zabo04 :

so the data is going into the columns on sheet 2

Zabo04 :

where is it coming from?

Customer:

Hey!

Customer:

I created all of the other columns after column one. The columns are in place with the format I am trying to create.

Zabo04 :

okay

Zabo04 :

but where did all the information come from?

Zabo04 :

oh I see it now

Customer:

The information came from a message database.

Zabo04 :

I didn't have the first column height set correctly

Zabo04 :

sorry about that

Customer:

Oh no problem!

Zabo04 :

I could only see the first line of text

Zabo04 :

so I was looking for that information on the other sheets

Customer:

I am so sorry! Sheet 2

Zabo04 :

I'm working on it now

Zabo04 :

I'm building formulas to parse the data, it's sometimes as much art as science

Customer:

Ha! Yeah, Im beginning to grasp that. =)

Zabo04 :

do they all get a repaged time: section?

Customer:

Ugh! They dont....only if they do not respond within the first ten minutes. Im sure that has to make things more confusing.

Zabo04 :

it does a little bit

Zabo04 :

I'm going to get everything else done, then break for dinner and figure that out

Customer:

That sounds good. Thanks for all of your help.

Zabo04 :

sure

Zabo04 :

Here is what I have so far, lines 2 and below. I am breaking for dinner and will think about the best way to handle the repage.

Customer:

This looks great so far!

Zabo04 :

thanks

Zabo04 :

all you have to do is copy down the formulas to the other rows

Zabo04 :

if you highlight the columns you want to copy in one row, it outlines the area in a black box. The lower right corner will have a square, left click on the square and drag the mouse and it will copy the selected columns over all those rows. Much faster than copy paste over a large area.

Customer:

Nice!

Customer:

And honestly, we do not repage very often. If I need to enter it manually, it is not a big deal.

Zabo04 :

i'm figuring it out now

Zabo04 :

i also have an issue with another entry that doesn't have a phone number following the doctor

Customer:

That really wont be a big deal. Because the information is not there, I may have to enter it myself.

Zabo04 :

okay

Zabo04 :

i found that

Zabo04 :

fixing one last thing

Zabo04 :

found another small issue, correcting it now

Customer:

No problem!- Thank you for your help!

Zabo04 :

sure

Customer:

Ill be back in five minutes.

Zabo04 :

I think I've got it working for the standard cases now

Zabo04 :

actually, this one has one more fix for the phone number of the doctor

Customer:

Dude, this looks fantastic! So all I have to do is copy the formula?

Zabo04 :

yes

Zabo04 :

that's it

Customer:

Great. I appreciate your help! You will make months to come extremely easy!

Zabo04 :

Glad I was able to help.

Zabo04, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 211
Experience: Experienced in Word, Excel, Access, Powerpoint, and Outlook.
Zabo04 and 3 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional