Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
E
E
evomed2020-08-10 08:09:17
excel
evomed, 2020-08-10 08:09:17

How to extract date from a cell?

Is there a text in cell D2:
DOEDED: 10/08/2020,

how to extract in e2 date 10/08/2020?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
D
datka, 2020-08-10
@evomed

UPD
spoiler
5f30f6be6b439006308689.png5f30f6c38cf1f431875942.png5f30f6c81844d068087216.png5f30f6cca8a44906658550.png5f30f6d36cfce928420150.png5f30f6d87a60a680394680.png

spoiler
old
5f30d88e8dceb990357787.png
5f30d897aa2a4132546244.png
5f30d89e88b0a699593123.png
Каждый не нужный столбик выбираете и жмете на на Do not import column
5f30d8a508cd1094509492.png

Similar questions
E
Eugene2019-10-15 23:20:51
What engine does snik.co run on? 2Reply
C
Chichi2017-03-08 17:20:09
How to visualize data (table with 4 options) in a chart using Excel? 1Reply
P
Pekky2019-08-10 14:32:03
An excel document after allowing editing, does it change the size of the columns? 1Reply
P
pikeyos2015-03-11 17:19:55
What sorting algorithm is used in Excel? 0Reply
C
citizentwo2019-08-13 23:25:19
How to copy data from certain cells to a new file with a shift? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question