Extracting date, month & year from a text string without using date format Help

		Microsoft Office Forums > Microsoft Excel > Excel
Extracting date, month & year from a text string without using date format Help

FAQ

Thread Tools

Display Modes

05-27-2021, 03:37 AM

Haha88

Extracting date, month & year from a text string without using date format Help

Windows 8

Office 2010 32bit

Advanced Beginner

Join Date: Mar 2015

Posts: 79

Extracting date, month & year from a text string without using date format Help

Dear community,

I'm looking for a formula which help extracting date, month & year only from this string "Apr 27, 2021 02:43:17 PM" without using the date format.

Please help!

Thank you,

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Empty date cell shows wrong month & year	Learner7	Excel	3	06-16-2019 11:09 AM
Excel day date month year Function	greginky	Excel	1	01-05-2016 02:19 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Excel 2013 – need help extracting date and time from text cell plus more.	Art Mann	Excel	1	07-18-2014 09:55 PM
Letter date changes when merging with Excel - not the format, the actual date!	Smallweed	Mail Merge	1	02-07-2014 06:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:28 PM.