Please provide complete requirements.
My apologies, I am out of ideas and opting out for other Professionals to answer. Please wait. You will be notified by email as soon as any Professional joins you.
Thank you for your patience.
I would be happy to help you with this. Can you upload the CSV file so I can have a look?If you attach it here, you should first put it in a compressed (zipped) folder.
Or, use wikisend.com or another file sharing site of your choice.
You do want this done in Excel, correct?
Sure, I assume you want the resulting column to replace the 2 originals ?
I'll make up a little sample workbook to show you how I'd do it, OK?
Here you go:
Hope that helps... let me know if you need anything else.
Of course if you'd rather send me the file I'd be happy to do it for you, too.
Glad I could be of help!Please feel free to post any additional questions or comments you may have regarding this issue.If you're satisfied, please don't forget to accept and rate my service - I don't get paid for my work until you do.
To ask me a future question directly, bookmark and use this link:
When you post a new question, please also put "FOR INGO U ONLY" at the beginning of the question; it'll help catch my eye.If I'm not online at the time, someone else may respond before I do.It is then completely up to you whether you work with that person or choose to wait for me.
Hi,just following up, were you able to use my solution? Please feel free to post any additional questions, comments or concerns you may have regarding this issue.
If you're not yet satisfied with the result, please let me know what is missing. I will do my best to make it right for you.
Otherwise, please don't forget to rate my service - I don't get paid for my work until your rating is received.