Hello!
New to the forum, but have found many old posts incredibly useful when googling for various excel formulas. However, I couldn't find any old threads relevant to my current problem.
I'm trying to figure out how to isolate and split out day of the week and the time ONLY in the following data (currently found in a single cell):
Wednesday, October 2, 2013 at 7:00 PM
The original data will not reformat as date/time, but rather is only recognized as general text (copied and pasted from a proprietary database w/ no other export option).
I've figured out how to separate the 1st word (the day of the week), but I'm having an issue with the time.
I was trying to use this formula:
=RIGHT(A2,LEN(A2)-FIND("at",A2)-2)
which worked beautifully until I got to Saturday!!
Is there anyway to adjust this formula so that it finds the LAST instance of "at" or specify that it shouldn't find part of a word?
Bookmarks