Morning All - Just a quick one. I have 2 cells i need to combine, but i only want part of the information out of one of them. How can I do this within excel?
this is an example
Cell 1 Cell 2 Cell 3 (needs to be
Havas 01/12/2013 Havas 01/2013
basically, i need to take the day out of an american date. I have several hundred lines to go through, and this data changes all the time, so doing it manually really doesn't appreal 1st thing on a monday morning!
Thanks
this is an example
Cell 1 Cell 2 Cell 3 (needs to be
Havas 01/12/2013 Havas 01/2013
basically, i need to take the day out of an american date. I have several hundred lines to go through, and this data changes all the time, so doing it manually really doesn't appreal 1st thing on a monday morning!
Thanks