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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02:31 PM.