VBA - One column to two columnn

[iwarecms]

Hi there,

I have an Excel sheet with one column and (for now) 70 rows.
I would like to split that one column into two columns.

I cannot use transpose because there is an image in the cell.
Does anybody has a solution for me ?

one_to_many_column.xlsx
	A
1	RED-Can-BG-A.0001 Fictieve ruimte Helpdesk Automatisering
2	RED-Can-BG-B.0001 Fictieve ruimte Helpdesk Automatisering
3	RED-Can-BG-BG-E Centrale hal Helpdesk Automatisering
4	RED-Can-BG-BG-R1 Kamer, gezamenlijk Helpdesk Automatisering
5	RED-Can-BG-BG-R2 Kamer, gezamenlijk Helpdesk Automatisering
6	RED-Can-BG-BG-TP Centrale hal Helpdesk Automatisering
7	RED-Can-BG-TR-M Technisch of tbv onderhoud Helpdesk Automatisering
8	RED-Can-BG-TR-P Technisch of tbv onderhoud Helpdesk Automatisering
9	RED-Can-BG-TR-V Technisch of tbv onderhoud Helpdesk Automatisering
10	RED-MOL-0-007 Clientenkamer Helpdesk Automatisering
11	RED-MOL-0-008 Clientenkamer Helpdesk Automatisering
12	RED-MOL-0-009 Clientenkamer Helpdesk Automatisering
13	RED-MOL-0-010 Clientenkamer Helpdesk Automatisering
14	RED-MOL-0-011 Clientenkamer Helpdesk Automatisering
15	RED-MOL-0-012 Clientenkamer Helpdesk Automatisering
16	RED-MOL-0-013 Clientenkamer Helpdesk Automatisering
17	RED-MOL-0-014 Clientenkamer Helpdesk Automatisering
18	RED-MOL-0-BERG Berging Helpdesk Automatisering
19	RED-MOL-0-ENTREE Gang(deel) Helpdesk Automatisering
20	RED-MOL-0-GANG Gang(deel) Helpdesk Automatisering
21	RED-MOL-0-HK Kamer, gezamenlijk Helpdesk Automatisering
22	RED-MOL-0-WR Sanitair Helpdesk Automatisering
23	RED-PAS-2-201 Clientenkamer Helpdesk Automatisering
24	RED-PAS-2-202 Clientenkamer Helpdesk Automatisering
25	RED-PAS-2-203 Clientenkamer Helpdesk Automatisering
26	RED-PAS-2-204 Clientenkamer Helpdesk Automatisering
27	RED-PAS-2-205 Clientenkamer Helpdesk Automatisering
28	RED-PAS-2-206 Clientenkamer Helpdesk Automatisering
29	RED-PAS-2-207 Clientenkamer Helpdesk Automatisering
30	RED-PAS-2-ENTREE Gang(deel) Helpdesk Automatisering
31	RED-PAS-2-GANG Gang(deel) Helpdesk Automatisering
32	RED-PAS-2-HK Kamer, gezamenlijk Helpdesk Automatisering
33	RED-PAS-2-SP Berging Helpdesk Automatisering
34	RED-PAS-2-WR Sanitair Helpdesk Automatisering
35	RED-SAS-1-108 Clientenkamer Helpdesk Automatisering
36	RED-SAS-1-109 Clientenkamer Helpdesk Automatisering
37	RED-SAS-1-110 Clientenkamer Helpdesk Automatisering
38	RED-SAS-1-111 Clientenkamer Helpdesk Automatisering
39	RED-SAS-1-112 Clientenkamer Helpdesk Automatisering
40	RED-SAS-1-113 Clientenkamer Helpdesk Automatisering
41	RED-SAS-1-114 Clientenkamer Helpdesk Automatisering
42	RED-SAS-1-ENTREE Gang(deel) Helpdesk Automatisering
43	RED-SAS-1-GANG Gang(deel) Helpdesk Automatisering
44	RED-SAS-1-HK Kamer, gezamenlijk Helpdesk Automatisering
45	RED-SAS-1-SP Berging Helpdesk Automatisering
46	RED-SAS-1-WR Sanitair Helpdesk Automatisering
47	RED-STU-1-101 Clientenkamer Helpdesk Automatisering
48	RED-STU-1-102 Clientenkamer Helpdesk Automatisering
49	RED-STU-1-103 Clientenkamer Helpdesk Automatisering
50	RED-STU-1-104 Clientenkamer Helpdesk Automatisering
51	RED-STU-1-105 Clientenkamer Helpdesk Automatisering
52	RED-STU-1-106 Clientenkamer Helpdesk Automatisering
53	RED-STU-1-107 Clientenkamer Helpdesk Automatisering
54	RED-STU-1-ENTREE Gang(deel) Helpdesk Automatisering
55	RED-STU-1-GANG Gang(deel) Helpdesk Automatisering
56	RED-STU-1-HK Kamer, gezamenlijk Helpdesk Automatisering
57	RED-STU-1-SP Berging Helpdesk Automatisering
58	RED-STU-1-WR Sanitair Helpdesk Automatisering
59	RED-Sta-0-001 Clientenkamer Helpdesk Automatisering
60	RED-Sta-0-002 Clientenkamer Helpdesk Automatisering
61	RED-Sta-0-003 Clientenkamer Helpdesk Automatisering
62	RED-Sta-0-004 Clientenkamer Helpdesk Automatisering
63	RED-Sta-0-005 Clientenkamer Helpdesk Automatisering
64	RED-Sta-0-006 Clientenkamer Helpdesk Automatisering
65	RED-Sta-0-007 Clientenkamer Helpdesk Automatisering
66	RED-Sta-0-BERG Berging Helpdesk Automatisering
67	RED-Sta-0-ENTREE Gang(deel) Helpdesk Automatisering
68	RED-Sta-0-GANG Gang(deel) Helpdesk Automatisering
69	RED-Sta-0-HK Kamer, gezamenlijk Helpdesk Automatisering
70	RED-Sta-0-WR Sanitair Helpdesk Automatisering
Blad1

 

[mrshl9898]

Which part would you split?

Perhaps

=LEFT(A1,FIND(" ",A1")) for the first section then =TRIM(MID(A1,FIND(" ",A1")+1,LEN(A1))) for the second.