Hello everyone
I have some strings like that
31 male 46 46 ذكر sleep ینام
How can I separate each part in a column to be like that?
male ذكر sleep ينام
I mean to have the English words and the Arabic words in four columns.
Split different parts in different columns
-
- PlatinumLounger
- Posts: 4913
- Joined: 31 Aug 2016, 09:02
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Split different parts in different columns
Have you tried the Range.TextToColumns method?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4913
- Joined: 31 Aug 2016, 09:02
Re: Split different parts in different columns
Yes I have tried TextToColumns but sometimes there are more than a word in one column that should be together. I don't need to rely on just spaces. Maybe the numbers existing is the key to split the words.
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Split different parts in different columns
That would be difficult. Could you attach a workbook with some samples that are representative of the data that you want to split?
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4913
- Joined: 31 Aug 2016, 09:02
Re: Split different parts in different columns
Here's sample file
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Split different parts in different columns
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4913
- Joined: 31 Aug 2016, 09:02
Re: Split different parts in different columns
Amazing solution. Thank you very much.