Forum

Splitting a date ce...
 
Notifications
Clear all

Splitting a date cell into 2 rows

4 Posts
2 Users
0 Reactions
148 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 
Hi, thanks for the help with the attached file.
The green table is linked to a website, there is no need to refer to column B (it's in Hebrew and I need it)
 what I need here - to split the date in column A so that the result is like
 in the example in columns J H
 Thank you very much for the help!!! Leah
 
Posted : 09/05/2023 5:42 am
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

It's not the prettiest solution but after splitting, checking and merging columns I was able to create the list of Dates and Time. Please see attached.

 
Posted : 10/05/2023 8:06 am
(@usb)
Posts: 244
Honorable Member
Topic starter
 
תודה רבה לך!!!!
 
 
 
Posted : 10/05/2023 8:30 am
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

בבקשה

 
Posted : 10/05/2023 12:30 pm
Share: