How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
Hello are there any alternatives to my helper, helper, helper columns please...!
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...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.