So I have a ton of cells with this sort of data format:
AAD PLP 10/24/2013
What I need to do is split the cell into two, with the text in one cell and the date in another. The text varies in length so I can't do text to columns. I thought maybe if I could add a colon between the last line of text and the first number in the date it would work, but I don't know how to do that. Any ideas?
Thanks!
IF the date is always at the end
=TRIM(MID(A1,1,LEN(A1)-10)
and
=TRIM(RIGHT(A1,10)
Do they work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks