Split Date and Text in Excel

[Jason MOloney]

Good Afternoon

I am a basic excel user,*need help with a formula to separate*date and text accordingly.
I need date in one column and rest of the data in one column.*Any excel expert feedback will be appreciated.

16 MAR 17 AUTOTRADER.CO.UK INTERNET GBR GBR
14 MAR 17 WWW.KITEPACKAGING.CO.U COVENTRY GBR
13 MAR 17 PAUL UK BROMPTON RD 411LONDON GBR
OT-QINGDAO YINGHE CAP MAKING CO. LTD XIAOYAO VILLAGE LIGEZHUANG TOWN JIAOZHOU
PayPal PayPal PPWDL5U3229UBLZCYC REF-PPWDL

Many Thanks
Jason

[AliGW]

Is there always a date at the start? Is it always in this format:

16 MAR 17

[Jason MOloney]

No few lines got date and few times data in random order as shown in 4th and 5th line. Thanks

[AliGW]

In that case, you need to provide a workbook with a lot more sample data, covering every likely layout. Nobody will be able to offer a solution based just on this one example that you have given.

[Glenn Kennedy]

Assume data start in A3, for the date, in B3:
=IFERROR(DATE(2000+MID(A3,8,2),MONTH(1&MID(A3,4,3)),DAY(LEFT(A3,2))),"")

and for the rest, in C3:
=IF(B3="",A3,MID(A3,11,255))

[Glenn Kennedy]

Incidentally if your location is your email address, I strongly suggest you replace it with a proper location; unless you LOVE spam.

[Jason MOloney]

Thanks Glenn. Problem sorted. Appreciated your response.
lol cracking word about my location, didn't bother too much when creating profile. Ill update it now.

Thanks for the formula again.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.