Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lucina Ferrrari   on Feb 18 In MS Office Category.

  
Question Answered By: Dirck Jansen   on Feb 18

Yeah... I thought about checking as well but then my thinking was that
Robert would only select the cells he wanted to alter.

I did think though that some of the months may be written out in full so I
used the full names for the Instr. My experience is that people sometimes
write Jul and sometimes July... Same for Jun / June ... Depending on the
price of eggs or wether it's Monday.

The split takes care of the Trim I think.

I thought it was a nice little problem.

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Replace date with a different format in same cell? Or get search suggestion and latest updates.


Tagged: