Some times data is received in YYYYMMDD for example : 20160124
In normal format Spend amount is represented using "," (coma) as thousand separator and "."(dot) as decimal but European format is the other way round.
Below excel formula will help you to extract first word in a cell
Below excel formula will extract middle word of the first three words in a cell.