Split them ,, each one in its own column ! , how can I do it ?

**ELGendi** · 02-01-2021, 04:44 PM

Hello everyone!
I have the date in a column , and the time in another column , I am using google sheet,

2021.02.01 13:00:00

I have a simple requirement to split each number in the above line and place each one in a separate column ,

would be like that:

|2|0|2|1|0|2|0|1|1|3|0|0|0|0

any idea how to reach that ?

Thanks in advance

**TMS** · 02-01-2021, 05:05 PM

If that's actually text that looks a bit like a date and time, try this dragged across:

Formula:

Please Login or Register  to view this content.

If it's a true date and time, try this dragged across:

Formula:

Please Login or Register  to view this content.

**JLGWhiz** · 02-01-2021, 06:27 PM

I had a little trouble deciding how to handle the mixture of string and date (time). But here is some code if yow want vba.

Please Login or Register  to view this content.

**TMS** · 02-01-2021, 07:03 PM

@JLGWhiz: will this code work in Google Sheets?

**JLGWhiz** · 02-02-2021, 05:55 PM

Originally Posted by TMS

@JLGWhiz: will this code work in Google Sheets?

Have no idea, have never used google sheets. But it works in Excel.

**TMS** · 02-02-2021, 06:13 PM

JLGWhiz:

... have never used google sheets ...

Me neither, but that appears to be what the OP is using

... am using google sheet

**JLGWhiz** · 02-03-2021, 02:57 PM

Well, the OP posted on an Excel forum, so I assume the Google sheet is imported to Excel. The code should still work.

**TMS** · 02-03-2021, 03:45 PM

Maybe not ... For Other Platforms(Mac, Google Docs, Mobile OS etc)

**JLGWhiz** · 02-03-2021, 03:59 PM

Originally Posted by TMS

Maybe not ... For Other Platforms(Mac, Google Docs, Mobile OS etc)

Well, it is up to the user to convert from vba ro Google script if that is what it takes. My expertise is limited to Excel and VBA, and I stress limited.

**TMS** · 02-03-2021, 04:06 PM

I'm not making an issue of it. I just asked the question (based on the OP's stated environment).

I've offered formula solutions which I assume will work in Google sheets, but I don't know for sure.

Probably best if we wait for the OP to let us know what, if anything, works for him/her.

**JLGWhiz** · 02-03-2021, 07:33 PM

No, I didn't take issue with the question, but I thought for arguments sake that if people post on an Excel forum and expect to get results in another application's format and/or programming language, then it needs to be made clear that, at least in my case, that won't happen. If a user imports data from another source into Excel then I will work with them to resolve their issues within the scope of Excel (and some other Microsoft applications). But not being a professional programmer, I do not study nor use programming languages from the various applications that might interface with the Microsoft applications. I see many specialized apps for use on websites to read or extract data, some written in Java script, but I have never had the inclination to try and become proficient at interpreting vba to other languanges and vice versa. At my age, I see no advantage to it.

**TMS** · 02-03-2021, 07:47 PM

Ah, go on, a "retired old geezer" can"t be that old

. I'll be seventy this year but I only realise that when I say it or write it down. Or do anything energetic. Or try to understand Power Query

**JLGWhiz** · 02-04-2021, 10:59 AM

My retirement year was in 2000 with full benefits. At age 70 I was still spry and active. Not so much anymore. But thankfully, the mind still clicks along enough to compile some decent code occasionally.
Regards, JLG

**ELGendi** · 02-05-2021, 10:43 PM

that helped me a lot , it was little longer but it did the job , I can't post here the google sheet to show you , but that below one helped me to handle the ":"when it was coming as a second digit in the time column:
=if(MID(B24,2,1) = ":","0",(MID(B24,2,1))
how to mark this as resolved ?

**TMS** · 02-06-2021, 01:04 AM

You're welcome.

**TMS** · 02-06-2021, 11:02 AM

Thanks for the rep.

Split them ,, each one in its own column ! , how can I do it ?

LinkBack

Thread Tools

Rate This Thread

Display

Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Re: Split them ,, each one in its own column ! , how can I do it ?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Concatenate Text in Column B Split in Multiple Rows for Each Number in Column A

split excel sheet based on column filter with protected column

Split workbooks by a column value and then split to worksheets by another column value

[SOLVED] PowerQuery - Split column into multiple columns based on another column

Need Macro code to split data split in 7 sheets based on variable rows in column A

How to split one column (Addresses, City, State, Zipcode, attn) into multiple column?

[SOLVED] Split One Column at Delimiter While Copying Contents of Second Column to Populate New Rows

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions