Despite having the world’s knowledge at my finger tips (i.e. the internet), I always forget little tips on how to do things in Excel. Yes, there’s bookmarks and other different ways to save websites, but I can never find them again after I saved them! So maybe writing a blog about it might be a good way to remember and also to help other people out there who come across this same problem.
This is one of the most annoying things when working with text and numbers in Excel… getting text to be in a “date” format. It makes life a whole lot easier when running queries or trying to sort/filter/order numerical values rather than text. While there are a lot of ways to do it (see this link for example), the following method is the most straight-forward way for me to convert text into a date/number and it works every time.
So here goes…
You come across dates as a string of text and they look like this:
01 01 2015
In my example, the dates come out as dd/mm/yyyy format but it really is text.
Select the text you want to convert and then go to ‘Data>Text to Columns’
A dialog box will open. Just keep the selection as ‘Delimited’ and click ‘Next.
On the next dialog box, select which ever delimiter is what separates the day, month and year for your text dates. In my example, “/” separates my text so I selected ‘Other’ and then inputted ‘/’. This puts each number into its own column. Click ‘Next’.
In the final dialog box, just keep everything the way it is and change the destination to where you want the new columns to be added. Click ‘Finish’.
This puts each number from the text dates into their own column.
Now I need to combine the numbers into the format that I want (yyyy-mm-dd). This requires a simple equation to merge the values in each column based on the order of the values I want.
Once the numbers are merged, I need to copy the values (not the equations) into a new column in the “date” format. Under ‘Edit’, select ‘Paste Special’ and then choose ‘Values’. Click ‘Ok’.
While the converted value is a number, in order to turn it into dates that Excel can recognize, I need to run a simple equation using ‘=Value (cell number)’.
I then redo the ‘Paste Special’ process on the ‘Value Equation’ column to move the values into a column that is formatted as ‘Date’.
There’s probably a quicker way to do this, but this is the best way I’ve found that provides the most control on addressing the number rather than fiddling with Excel’s functions to format columns… and it works every time.
It’s really great to hear that York House School, one of the most prestigious private schools in Vancouver, puts resources towards supporting students by also emphasizing personal/mental health for students. Last year I had a great time sharing my experience with the inner workings of the United Nations with the School’s model UN class. So I was happy to give another talk when the counseling team recently invited me to speak to sixty Grade 12 students about how I got into the UN and the unconventional way that my life has taken. The purpose of the talk was to support the students’ personal health and planning and to highlight that there are alternative paths after high school.
“Global Citizenship in the 21st Century” was the topic and it’s quite broad… so it made sense that I would talk about my UN experience…. but I also wanted to share my experience and views on how becoming a “global citizen” isn’t necessarily a fixed path. While I’ve enjoyed the work I’ve done internationally, the most valuable thing that I’ve learned from these experiences isn’t so much the traveling and living abroad, but to be open, curious, understanding and respectful of the people and the environment. Honestly there are people I know who’ve not really traveled much and who are more “global” in their outlook… while there are some people I’ve met during my travels who are not as “global” in perspective as you might think.
I never thought of being a “global citizen” when I was about to graduate from high school (and I still don’t). I didn’t really have an idea of what I wanted to do after grade 12. I figured going to University was the thing to do since everyone else was doing it.
There’s a lot of pressure (and advice) to start thinking about and doing something about your career and/or life when it’s time to graduate high school. From the sounds of it, the current generation of students needs to be “well rounded”, with lots of volunteering and academic experiences under their belt, in order to be considered for university. I’m all for balancing high school and extra curricular/volunteering activities, but I don’t think it should be what defines whether or not you can go to university. That’s too much pressure, physically and mentally, on students… instead, why not make it mandatory that after high school university-bound students are ask to take, say, six months off and do something with this time? And as part of university admissions to ask applicants what they did with these six months and why…
Part of the process of being a global citizen is to figure out who you are, what you like and/or don’t like. And that means trying things and exploring your possibilities. It’s not possible to have all the answers from just books alone, there’s a lot that can be learned and that can help a person grow through experience. It shouldn’t be forced, but rather do things that you want to do rather than what is expected of you… All this helps not only to build up a resume but also helps with personal growth and development. It’s something I’ve kept in mind and it’s led me to spend time in the Arctic, work for a car company in Japan, join the United Nations in Asia and Europe, and even earn my Masters degree while living and working in Bangkok.
I was interested and had the opportunity to go to University. Is it the place that will help you find a job after? Not really. It’s called ‘higher education’ after all. Yes, having a university degree opens doors, but it shouldn’t be the main purpose of going to secure a job afterwards. A lot of people try to finish as fast as they can… after 4 years and then what? Work? My advice is to embrace the culture and environment for as long as you think you can or need to… it’s a great place to explore who you are, meet people with different ideas, and learn things. It’s a big jump from high school to university in terms of life experience so what’s the rush of getting it over with?
There’s no perfect way of doing things in life. I’ve learned that the hard way. It was interesting to see the student’s faces when I told them that it took me seven years to finish my undergraduate degree, which included dropping out of university. Burn out is a part of life and that’s ok. It’s an opportunity to learn from and experience these kind of challenges in life. I was fed up with university and so I decided to take time off… and it was one of the best decisions I’ve made. Not only did I realize the trials and tribulations of a working life, but I learned that I wanted to do more and see the world… which led me to taking a couple years off to live and work in the Arctic and Japan. Again… I would have never expected that coming out of high school.
Relationships are as important as the stuff you learn from books. So while the UN is famously known for “global citizenship”, making the world a more peaceful, stable, safer and healthier place also requires patience, understanding, and acceptance. Book smarts helps you understand the world, but it’s relationships that helps to change it. While I got my foot in the door with the UN with academics and life experiences, it’s the relationships that I’ve nurtured that has helped me continue working on and staying connected with global issues.
Life’s a journey. Having set plans and ideas about what to do with life is great, but you also have to be ready for those unexpected twists and turns. There will be times when you feel in control, and other times when things just feel out of control. Priorities change in life and it’s important to grow and adjust with them.
So what does it mean to be a “global citizen”? It isn’t about how much one has traveled, but, rather, their perspective, outlook, and curiosity in understanding the world around them, whether it’s in one’s own community or in some village in a developing country. That means being open to exploration, discovery, learning, and empathy… and using those experiences to grow as a person and to give back to society in a meaningful way.
Having spent a lot of my adult life traveling and working abroad, I’ve usually make an effort to try different airlines when I can. And because of that I’ve been on some interesting, stressful and adventurous flights… but the worse experience in recent memory has been the service I received on Air France.
You’d think that in normal circumstances, especially for transcontinental/international flights, airlines make an effort to provide a relaxing and enjoyable experience. I usually try to avoid low-cost airlines for this reason… I want to enjoy the experience. Having taken Air France a few times, the quality of service and food is decent, so I was quite shocked last month when I received one of the worst experiences ever.
Knowing that I had to mentally and physically prepare myself for a trip to Canada from France with my 2-year old daughter, I’d made every preparation I could think of to make sure the flight would go smoothly. Getting rest before the flight. Check. Headphones and toys for the flight. Check. Mid-plane seats for the both of us. Check.
So as we got on the plane for a 13-hour flight which included a change-over in Amsterdam, I was ready. What I wasn’t ready for was the on-board service I received from a flight attendant before taking off on the first-leg of our flight from Marseille to Amsterdam. I made sure to buy a seat for both of us because having my daughter, who had just turned 2 a day before the flight, sitting on my lap for the trip wasn’t going to happen… and travelers are allowed to reserve seats for an infant.
And as it goes with any child, no matter how much you prepare, things just don’t go according to plan. Théa normally travels well, but when we had to wake up at 5am to drive an hour to get to the airport to catch our flight, you’d expect any child to be grumpy. And so she was as we found our seats and were getting ready for the departure… that meant a lot of crying and frustration. Basically she didn’t want to sit in her seat and be buckled in.
I had already asked one of the head flight attendant to keep our stroller (Dear all airlines, the Babyzen Yoyo stroller isn’t the only stroller made for traveling – see the Mountain Buggy Nano!) so I could have it for the transfer in Amsterdam. She was more than accommodating so I thought “Great, I’ll be able to ask for help if/when I need it for this trip.” Oh, was I wrong…
The second we got to our seats, Théa wouldn’t sit still and she started to get frustrated and cry. Since I had to get her to use her seat belt before taking off, it made the situation even more tense. I was given a warning by the second flight attendant that she had to be strapped in. As the plane was leaving the gate to take off, this same flight attendant came back again and told me, in the most obnoxious and least courteous tone, that the flight would not take off without Théa being buckled in. So I asked to get the child seat belt so she could sit on my lap for take off. Here’s where it gets worse…
No, you can’t have a child seat belt. It’s your fault.
She said, “No, you can’t have a child seat belt. It’s your fault.” implying that it was somehow my fault that I had bought a seat for Théa and that she had to use it even though she was crying and unwilling to sit in the seat. After that she walked away. As I struggled to calm Théa, both the guy sitting beside me and I looked at each other and wondered what just happened.
Within a minute the head flight attendant came to see what was going on. After a bit of discussion, she quickly made an assessment of the situation and came back with the child seat belt and a couple small muffins for Théa. This dramatically reduce not only my stress but also Théa’s stress as she calmed down, sat on my lap and allowed to be buckled in, and happily enjoyed her snacks… she fell asleep soon after and only woke up just before we landed in Amsterdam.
It’s better to be gentle and show some empathy rather than to be aggressive.
Inter-personal communication is so underrated yet so important especially in stressful moments like I experienced on this flight. As my neighbor, who looked like he was a father of two boys, told the head flight attendant, “It’s better to be gentle and show some empathy rather than to be aggressive.”
Whether it’s about parenting or the challenges in life, this reaction of putting blame or faulting others does not help and can create more animosity and negativity that we as individuals and as a society don’t need.
Having people around for both the good and bad times is so underrated… and for this I am thankful on this Thanksgiving day for the friends and family near and far who’ve been there when I needed it most these past couple of years.
One of the most peculiar things I have found in times of trauma, crisis or grief is you never know who will be in your support system when you need it most. And you never know what that support will be… it might be just having a shoulder to cry on, an ear to listen, an invitation to do something, words of wisdom, a hand to help, or a hug for comfort. Sometimes the best support can come from the most unexpected place during an unforeseen situation.
Coincidentally, today is also World Mental Health Day with the theme of “psychological first aid“. When terrible things happen, not only should people be able to provide first aid, but also be able to reach out with a helping hand to those who are affected and provide much-needed psychological support. Empathy and psychological first aid is definitely useful… we will at some point in our lives be at the receiving or supporting end of a trauma, crisis or grief.
General health care never consists of physical first aid alone.
Today is World Suicide Prevention Day… and by the time I finish writing this post, more people will have died by suicide. According to the World Health Organization, suicide kills one person every 40 seconds. That’s on average about 800,000 people a year – and for every person who dies by suicide, many more people attempt suicide every year.
It’s a staggering figure and a significant one that demands more attention. It happens to the rich and poor… young and old… the mentally stable and ill. Suicide does not discriminate. While we typically think suicide is linked to mental health issues (i.e. depression and alcohol use), many suicides also happen impulsively in moments of crisis and life stresses such as financial problems, relationship break-up or chronic pain and illness. Suicide rates are also high amongst people who experience discrimination, such as refugees, migrants, indigenous peoples, LGBTI persons, and prisoners.
Talking about suicide is no joke. There’s a fine line between joking about it and to actually thinking about self-harm and suicide. And if this leads to an attempt, then it’s definitely time to pay attention before it’s too late. The Canadian Mental Health Association has an easy way to remember the warning signs:
There are plenty of resources about suicide prevention and education. Ones that I’ve found useful in Canada include:
I found these resources useful because they focus on providing information about preventing and understanding suicide, as well as helping me process my experience with a suicide death. One of the best things when I moved back to Vancouver was to find that there’s a specific suicide support service called SAFER (Suicide Attempt Follow-up, Education and Research). Not only is SAFER a community-based outpatient service that provides counseling for people who are feeling suicidal, it provides free counseling for people bereaved by a suicide death.
From a public health policy perspective, suicide is a complex issue and so prevention requires coordination and collaboration between various health and non-health sectors – WHO’s recommendations for prevention and control includes:
Reducing access to the means of suicide (e.g. pesticides, firearms, certain medications)
Reporting by media in a responsible way
Introducing alcohol policies to reduce the harmful use of alcohol
Early identification, treatment and care of people with mental and substance use disorders, chronic pain and acute emotional distress
Training of non-specialized health workers in the assessment and management of suicidal behaviour
Follow-up care for people who attempted suicide and provision of community support
Suicide prevention is a good goal… in the meantime many people have to deal with the aftermath. I found the below video really helpful to connect with what I am going through, and also to share with people who want an insight into the grief from suicide.
Grief is a deeply personal experience and journey. Everyone goes through it differently. It’s not something you get over, but rather something you live with. It’s even more apparent when death comes too quickly. Phoebe Rose Doull-Hoffman was born in 2010. She had been diagnosed with mixed lineage (MLL+) infantile leukemia since she was two months old. This is an aggressive and difficult to treat and cure leukemia with a very poor prognosis – just 20% of babies with high risk disease survive five years. Phoebe passed away in November 2015 and would’ve turned 6 this week.
To honor Phoebe, and as part of the Phoebe Rose Rocks Foundation to raise awareness and funds for childhood cancer research, Marion (Phoebe’s aunt and my close friend), her family and friends organized a dinner last weekend for families staying at the Ronald McDonald House. I felt really honored to be invited to join in this activity. Not only because it’s a special thing to be included in someone’s journey through grief, but it’s also how I’ve been living with my own grief – by doing things that Muriel would find fun and for a good cause.
For prep day at the Pacific Institute for Culinary Arts (PICA), we met Marion’s husband Scot who works at PICA and was the leader of our group “Team Vancouver”. It was my first time at PICA and I was seriously impressed by the facilities and makes me want to take a class there, especially when Scott revealed the meal we would be serving. My mouth couldn’t (and still can’t) stop watering.
For the vegetarians, grilled summer vegetables on a bed of salad in a spinach wrap.
Caesar-salad (I made the dressing from scratch, with help from the chef.)
3-bean salad in a lemon-infused vinagarette.
100+ hand-made chocolate cupcakes topped with icing and sprinkles.
I’d heard of the Ronald McDonald House before but never new it played such an important and critical role for families and children. For over thirty years, Ronald McDonald House BC and Yukon (RMH BC) has been providing accommodation for seriously ill children and their families when they must travel to Vancouver for their child’s major treatment. Originally located in a 13-bedroom home in Shaughnessy, the House is now in an amazing 73-bedroom complex, including multiple kitchen facilities, lounge areas for families and children, indoor and outdoor exercise gyms, and a very cool indoor slide, on the grounds of BC Children’s Hospital.
We were so prepared that the team set up and was ready well before families trickled in for dinner. With a little bit of time to spare, we were given a tour by the friendly volunteers who showed us around and even let us try the slide. The highlight of the night was serving dinner to the families who were staying at the House. It’s a humbling experience to see that a small gesture of cooking for someone can bring relief to many of the moms, dads, siblings, and families who were there for their sons or daughters.
Grieving is different for everyone. And that there good and not-so-good milestones along the way. Doing something like this really helped me with my grief and I wouldn’t hesitate to get back in the kitchen to do it all over again!
It’s World BreastFeeding Week and UNICEF and WHO are running full-steam ahead with their campaigns. Yet, while breastfeeding is an ideal, this kind of campaign is adding extra pressure on new parents, particularly moms, if they can’t or decide not to breastfeed based on their needs and situations.
Breastfeeding is an ideal – and this campaign clearly wants people to support it – yet for most moms and dads who’ve gone through the realities of ‘natural’ feeding, it’s not such a rosy picture. There’s the difficulties of latching, the pumping, the sleepless nights, the constant social pressures of equating breastfeeding to being a good parent.
According to Maria Iacovou, PhD, a sociologist at the University of Cambridge in England and an author of the study, the benefits of breastfeeding is not new information. “But what is new – and urgent from a public health perspective – is that there is increased PPD risk among women who plan to breastfeed and then are not able to.”
The study suggests that women who wanted to breastfeed and did not may be in the most vulnerable position, possibly because they feel disappointment and guilt in addition to not getting the physiological benefits of breastfeeding.
If moms who are depressed fail at breastfeeding, that is another strike against their perceptions of being a good mom.
The study ultimately underlines the importance of providing expert breastfeeding support to women who want to breastfeed, but also to provide compassionate support for women who had intended to breastfeed, but who find themselves unable to.
I’ve been told that World Breastfeeding Week is trying to target developing countries because breastfeeding is the best way to provide infants with the nutrients they need. If this is the case, the message could be more specific, otherwise it might inadvertently be perpetuating social pressures leading to unnecessary stress and anxiety for parents who have the choice to decide how they want to feed their child.
Living with grief definitely affects my mental health and it’s made me realize that despite the “norm”, everyone at some point suffers from a mental health issue. It’s pretty easy to think about our physical health and take steps to keep in shape – like exercising, watching what we eat, or even wearing sunscreen to protect our skin. According to the Canadian Mental Health Association (CMHA), safeguarding our mental health is just as important.
Many of us don’t consciously make an effort to stay mentally healthy. Mental health isn’t just about mental illness, its about feeling good about who you are, having balance in your life and in your thinking, and responding constructively to life’s highs and lows. Everyone should practice good mental health.
Because my grief is linked to mental health, I jumped at the chance to volunteer for the Ride Don’t Hide movement to support and raise awareness about why mental health is so important.
My family and I teamed up to be route marshals for an important segment of the 60km route of the event. This “hair-pin” turn off the No. 2 Road Bridge in Richmond was a tricky one because the cyclists needed to come off the bridge and immediately turn onto a small bike path that led them to a residential area just across from the Vancouver International Airport. Of the 1200 cyclists that registered for the event, half of them (around 600) passed our post.
As the crew for the No. 2 Road Bridge and Dover Park, we cheered riders on and directed riders to keep to the route… I even had to help someone fix their bike chain! All in all, waking up early to volunteer for a couple hours on a Sunday morning was really rewarding – the sunny weather definitely made the day much more enjoyable!
The Ride Don’t Hide movement began on 1 August 2010, as Vancouver teacher and newspaper columnist Michael Schratter cycled 40,000 km, crossing six continents and 33 countries. In addition to raising funds for CMHA, Michael’s mission was to circumnavigate the world, sharing stories with people in different countries, to bring awareness to the stigma surrounding mental illness.
The more I get involved in postpartum and mental health issues, the more I see that there are lots of awareness-raising events about them (at least in Vancouver). After the interview with CBC, I was pleasantly surprised when I was contacted to join this year’s “Climb Out of the Darkness” events in British Columbia.
I supported the Vancouver event (Facebook page) and joined the walk organized by Kristen Walker, an instructor at the University of British Columbia, who decided to raise awareness about postpartum issues after the death of someone she knew and their family suffering from postpartum psychosis.
Climb Out of the Darkness is one of the world’s largest events raising awareness of maternal mental illness, like postpartum depression. It is held on or near the longest day of the year to shine the most light on this issue by getting people to join together to climb mountains and hike trails to symbolize the rise out of the darkness of maternal mental illness into the light of hope and recovery.
In addition to fundraising more than $3000 to support postpartum support services, the Vancouver event also brought together around forty people who braved the rain and cold to come out for the morning walk. It was also great to see CBC interviewing people and covering the event.
The turnout was great and it was nice to see that there was this grassroots support for postpartum issues. But definitely more is needed to raise awareness and get people to talk about and share their experiences. The statistics are too real to ignore.
Virtually all women can develop mental disorders during pregnancy and in the first year after deliver.
According to the World Health Organization, virtually all women can develop mental disorders during pregnancy and in the first year after deliver – about 10% of pregnant women and 13% of women who have just given birth experience a mental disorder, primarily depression, and this is even higher for developing countries (15.6% during pregnancy and 19.8% after child birth).
Despite the emphasis in society on the postpartum challenges and struggles women and mothers face, this is also an issue for men whether it’s suffering from similar depression or having to support their partners. More dads need to be involved and speak out about their experience.
There’s something about getting real mail, letters in particular, that can’t be replaced with emails, tweets, WhatsApp messages, SMS, etc.
When my friend Joya asked me last summer if I wanted to participate in ‘The World Needs More Love Letters‘, I thought sure why not. I wasn’t in the right state of mind to be thinking too deeply or analyzing what for – instead I just thought whatever could be done to ease my pain and loss would be ok. I wasn’t sure how I would feel about getting letters from total strangers, but if it could somehow fill a little bit of the hole that I felt I had or just to brighten my day, I was all for it.
Not only did the editors accept my story for letter writing, but they also featured it on Day One of their ’12 days of lover letter writing’ campaign over the Christmas holidays.
I wasn’t expecting such a response. I received over 450 letters from 11 countries including the USA, Canada, France, Netherlands, UK, Switzerland, Australia, Sweden, Denmark, Italy and Mexico. Letters came from 49 out of the 50 States in the USA (no letters from Wynoming). Every letter was read before it reached me because we weren’t sure what to expect. What Joya found was that not only were the letters overwhelmingly positive, they also contained love from afar, encouragements, prayers, thoughts and motivation for me to succeed.
People are wonderful. I was blown over by the responses and the inherent goodness in people, young and old.
Children, teenagers to adults from around the world sent letters that were poignant, sweet, raw, and insightful. I couldn’t stop reading them. People shared similar tragedies in their life, others wanted to reach out with words wrapped in a hug, and others just wanted to show that they care for another fellow human being. The letters are full of words of wisdom, philosophy, heartbreak, art and poems.
It’s nice to know that people are inherently good and everyone shares a life of struggles, love, joy and humour. These real emotions somehow get lost in translation with all the digital ways we can communicate so it’s nice to know that ‘The World Needs More Lover Letters‘ exist.
Getting a letter (i.e. words on paper, drawings, photos, postcards, etc.) in the mail is real, tangible, and more supportive and comforting than you know.