Converting text to a date

S

sobrien

Board Regular
Joined
Feb 28, 2006
Messages
179
I have downloaded the following text from the internet and pasted it into excel as follows in A1, A2....
Thu 25 Mar
Fri 26 Mar

They are not in date format and I want to convert them into dates in excel format
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
sobrien said:
I have downloaded the following text from the internet and pasted it into excel as follows in A1, A2....
Thu 25 Mar
Fri 26 Mar

They are not in date format and I want to convert them into dates in excel format
Click to expand...
Try this formula entered in B1:

=--MID(A1,FIND(" ",A1),7)

Format as Date.

Copy down as needed.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
convert day abbreviation (Mon,tue,wed.....) To date using Week Number
Replies
4
Views
295
lrobbo314
lrobbo314
N
  • Question Question
Convert Quarter to Monthly payments by using offset formula
Replies
1
Views
75
Cubist
Cubist
SRMPURCHASE
  • Question Question
#NUM! ERROR
Replies
2
Views
250
SRMPURCHASE
SRMPURCHASE
G
  • Locked
  • Question Question
VBA Userform - Change from 1900 Date Format to Long Date
Replies
1
Views
77
Peter_SSs
Peter_SSs
G
  • Question Question
Date Convert Help
Replies
7
Views
111
Cubist
Cubist

Forum statistics

Threads
1,224,585
Messages
6,179,703
Members
452,938
Latest member
babeneker

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top