Extract from Cell with less helper columns...

[How_Do_I]

Hello are there any alternatives to my helper, helper, helper columns please...!

Excel Workbook
	A	B	C	D	E	F	G
1	x;;;;;;;;xx;SITE NAME: XI/A/58;xxxxxxxxxxx	13	31	18	11	7	XI/A/58
2	x;SITE NAME: XI/A/15A;xxxxxxxxxxx	3	22	19	11	8	XI/A/15A
3	xxxxxxxx;SITE NAME: XI/A/5;xxxxxxxxxxx	10	27	17	11	6	XI/A/5
4	xxxx;SITE NAME: XI/A/115A;xxxxxxxxxxx	6	26	20	11	9	XI/A/115A
5	xxxx;SITE NAME: XI/A/115;xxxxxxxxxxx	6	25	19	11	8	XI/A/115
Sheet1

 

[How_Do_I]

Hello Rick, It is the second semi-colon from the left that ends my area of interest in the cell... After that, there are a varying number of semi-colons in the data. The biggest amount of characters in a cell in the batch of data that I'm currently looking at is 826... I plastered my sample data with semi-colons to test the formula I had before I asked for help combining it all together... sorry to mislead you.

 

[Rick Rothstein]

Hello Rick, It is the second semi-colon from the left that ends my area of interest in the cell... After that, there are a varying number of semi-colons in the data. The biggest amount of characters in a cell in the batch of data that I'm currently looking at is 826... I plastered my sample data with semi-colons to test the formula I had before I asked for help combining it all together... sorry to mislead you.

Is that first semi-colon directly in front of "SITE NAME" text as some of your examples in Message #1 show? If so, this formula should work for you...

=MID(A1,FIND(";",A1)+12,FIND(";",A1,FIND(";",A1)+1)-FIND(";",A1)-12)

 

[How_Do_I]

Thanks Rick...