Text to Columns via vba code

[mdd16]

[9:06 am, 14/10/2022] Raj: Dear all.
Please look at adapter issues
Do you have any reason for it?
[9:08 am, 14/10/2022] Mohan: We had tightened them before install ..
Please share your experience on this

I have this text in col A. Each line of text in separate row.
I want to move all the text that appears after second semi-colon to col B in same row.
In case there is no semi-colon then also do the same.

When I use "Text to Columns" command then problem I face is that text is separated to three columns due to two semi-colons in string. of course the second issue is that when there is no semi-colon, the text stays is col A only.

Image of what I want to achieve is attached.

Any help will be greatly appreciated.

 

[Kerryx]

Don't know what version of excel you have but here is a formula option

Book1
	A	B	C
1	[9:06 am, 14/10/2022] Raj: Dear all.	[9:06 am, 14/10/2022] Raj:	Dear all.
2	Please look at adapter issues		Please look at adapter issues
3	Do you have any reason for it?		Do you have any reason for it?
4	[9:08 am, 14/10/2022] Mohan: We had tightened them before install ..	[9:08 am, 14/10/2022] Mohan:	We had tightened them before install ..
5	Please share your experience on this		Please share your experience on this
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=IF(SEARCH(C1,A1,1)=1,"",LEFT(A1,SEARCH(C1,A1,1)))
C1:C5	C1	=IFERROR(IF(FIND("[",A1)=1,RIGHT(A1,LEN(A1)-FIND(":",A1,5)),A1),A1)

 

[mdd16]

Thanks so much for your kind help bi will give it a try.