I have a simple table which seperates a bunch of text and the notes out from each other. It seems to work great until you get to data of a particular length then #VALUE! returns.
IS there a way to get around this character limit?
IS there a way to get around this character limit?
Note splitter.xlsx | |||||
---|---|---|---|---|---|
B | C | D | |||
4 | Description | Description/ no notes | Notes | ||
5 | DON’T USE | DON’T USE | |||
6 | Test 2 Note test test test test test test test | Test 2 | Note test test test test test test test | ||
7 | test 2 | test 2 | |||
8 | note this | note this | |||
9 | test note test note test note | test | note test note test note | ||
10 | this is desc, Note this | this is desc, | Note this | ||
11 | Note this | Note this | |||
12 | Inspect (detailed) flight control, landing gear control and engine thrust control cables at turns in the fuselage and all cables in protected but unpressurized areas for wear, broken strands, corrosion, kinks and bird caging. Check end fittings, turnbuckles, pulleys, brackets, fairleads and quadrants for wear, corrosion, cracks, and security. NOTE: Thrust control cables are applicable only to airplanes without full authority electronic propulsion control systems. | #VALUE! | NOTE: Thrust control cables are applicable only to airplanes without full authority electronic propulsion control systems. | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C5:C5000 | C5 | =IF(B5:B5000<>"",IF(ISNUMBER(SEARCH("Note",B5:B5000)),LEFT(B5:B5000,SEARCH("Note",B5:B5000)-1),B5:B5000),"") |
D5:D5000 | D5 | =IF(B5:B5000<>"",IF(ISNUMBER(SEARCH("Note",B5:B5000)),RIGHT(B5:B5000,LEN(B5:B5000)-SEARCH("Note",B5:B5000)+1),""),"") |
Dynamic array formulas. |