I have used your Excel help support a couple of times - last in June. I believe the PC-Guy was the support person that helped me. The service was very good. I need your support again. I need someone to help provide me with formulas to separate a single cell data item - separating both teacher and teacher names to last name and first name in separate columns. I can send the actual file and what is desired. Thank you. I hope to hear from you soon. Tim XXXXXXXXXXXXX@XXXXXX.XXX
I want to send you the file so I can view how you did it.
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
I can helop you
Please attach the file using the paperclip icon at the top of this chat window
it says image
but it works for
I highlighted in 'yellow' what is desired; do you have it?
the file is ther
let me see if I can open it
i can do it
so you want me to separate the names
capitalize only the first letter of each?
Yes, I want to separate the data into separate columns as noted in the yellow
Make sure you remove the word 'TEACHER' from the teacher name, and just have the last name and first name.
yes, i know some of them don't have it
so it will make it a little more complex
but nothing I cannot handle
just give me a few minutes
still working it out
Thank you; I know you will do your best!
alright it will take a little longer than I thought
very complex formula
but it works
Ok, good. Can I review it?
give me a min to upload
http://ge.tt/5dWnjAx/v/0?cPLEASE REMEMBER TO RATE MY SERVICE SO I GET PAID FOR MY TIMEYOU DO SO WITH THE SMILEY FACES BELOW THIS CHAT WINDOW
did you get the file??
Yes, I got the file. Will I be able to simply copy the formulas to another file, or are there certain parameters I need to know?
just make sure that everything is in the same columns
Ok, great, I will do so. Thanks again for your help. Now, how shall I pay?
do you have smiley faces below this chat?
you can click one of those
"good" "excelent" service ect..
Yes, I see them; so I just click on one of them?
whatever you think of my service
should be excellent
Ok, I will. Thank you again.
it always is
Yes, it always is...thanks again Andrew...
after you rate, I will have the system send you an email with instructions on how to request me again in the future if you need me