Hello All,
This thing has stumped me.
I trying to separate a bullet point list from one cell into different columns using this formula:
=TRIM(LEFT(SUBSTITUTE(MID(D4,FIND("|",SUBSTITUTE(D4,"•","|",1))+1,LEN(D4)),"•",REPT(" ",LEN(D4))),LEN(D4)))
It works most of the time, but sometimes it doesn't and I cannot figure out why.
For example,
I have two cells here and one works, the other doesn't. I have found that if I reduce the characters in the first cell by deleting the text in red, the formula works.
What is going on here? Is this a character limit issue?
[TABLE="width: 500"]
<tbody>[TR]
[TD]
<tbody>
[TD="class: xl65"]• Elegant All White Fra me Design • Super Lightweight Powder Coated Aluminum Frame Construction • Detachable Pin-Hinged Sections for Easy Assembling and Disassembling • Includes Four 24"W x 46"H Sections • Each Section Color Code Marked For a Quick Setup • Fire Retardant Treated Dual Scrim Screen Faces • Use in Conjunction with Lighting for Color Wash Effects • Carrying/Storage Bag is Included: (25" x 46.75" x 4.25") *use all necessary safety precautions when using heat and electrical related devices near the stretch screen **SCRIM CLEANING CARE: Dry-Clean or Machine wash in cold water (Do not bleach). Hang dry or Tumble dry at "low" to no heat. Do not iron. *Flame retardant must be retreated after washing or dry-cleaning. Other Related Products • SWF7246WHT 72"W x 46"H All White Pro DJ Facade ALL BLACK PRO DJ FACADES • SWF4846BLK 48"W x 46"H All Black Pro DJ Facade • SWF7246BLK 72"W x 46"H All Black Pro DJ Facade BLACK FRAME WITH WHITE SCRIM PRO DJ FACADES • SWF4846B 48"W x 46"H Pro DJ Facade • SWF7246B 72"W x 46"H Pro DJ Facade • SWF9646B 96"W x 46"H Pro DJ Facade • SWFTT5816B 58"W x 16"H Table Top Pro DJ Facade OTHER SCRIM WERKS™ PRODUCTS • Light Columns • 12"x12" Square Truss Slip Screens™ Stretch Covers • Banquet Table Slip Screens™ Stretch Covers • Lighting/Speaker Tripod/Crank Stand Stretch Covers • X Stand Slip Screen™ Stretch Covers • Video Stretch Screens • Triangular Decor Scrims • Decor Display Panels[/TD]
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65, align: center"]#VALUE![/TD]
</tbody>[/TD]
[/TR]
[TR]
[TD]
<tbody>
</tbody>[/TD]
[TD]
<tbody>
[TD="class: xl65"]Sleek All Black Stealth Frame and Scrim Design[/TD]
</tbody>[/TD]
[/TR]
</tbody>[/TABLE]
Here is an online workbook with the example. https://1drv.ms/x/s!Avza4YgA-BnDjBwMZ6nL1YudMvzq
This thing has stumped me.
I trying to separate a bullet point list from one cell into different columns using this formula:
=TRIM(LEFT(SUBSTITUTE(MID(D4,FIND("|",SUBSTITUTE(D4,"•","|",1))+1,LEN(D4)),"•",REPT(" ",LEN(D4))),LEN(D4)))
It works most of the time, but sometimes it doesn't and I cannot figure out why.
For example,
I have two cells here and one works, the other doesn't. I have found that if I reduce the characters in the first cell by deleting the text in red, the formula works.
What is going on here? Is this a character limit issue?
[TABLE="width: 500"]
<tbody>[TR]
[TD]
<tbody>
[TD="class: xl65"]• Elegant All White Fra me Design • Super Lightweight Powder Coated Aluminum Frame Construction • Detachable Pin-Hinged Sections for Easy Assembling and Disassembling • Includes Four 24"W x 46"H Sections • Each Section Color Code Marked For a Quick Setup • Fire Retardant Treated Dual Scrim Screen Faces • Use in Conjunction with Lighting for Color Wash Effects • Carrying/Storage Bag is Included: (25" x 46.75" x 4.25") *use all necessary safety precautions when using heat and electrical related devices near the stretch screen **SCRIM CLEANING CARE: Dry-Clean or Machine wash in cold water (Do not bleach). Hang dry or Tumble dry at "low" to no heat. Do not iron. *Flame retardant must be retreated after washing or dry-cleaning. Other Related Products • SWF7246WHT 72"W x 46"H All White Pro DJ Facade ALL BLACK PRO DJ FACADES • SWF4846BLK 48"W x 46"H All Black Pro DJ Facade • SWF7246BLK 72"W x 46"H All Black Pro DJ Facade BLACK FRAME WITH WHITE SCRIM PRO DJ FACADES • SWF4846B 48"W x 46"H Pro DJ Facade • SWF7246B 72"W x 46"H Pro DJ Facade • SWF9646B 96"W x 46"H Pro DJ Facade • SWFTT5816B 58"W x 16"H Table Top Pro DJ Facade OTHER SCRIM WERKS™ PRODUCTS • Light Columns • 12"x12" Square Truss Slip Screens™ Stretch Covers • Banquet Table Slip Screens™ Stretch Covers • Lighting/Speaker Tripod/Crank Stand Stretch Covers • X Stand Slip Screen™ Stretch Covers • Video Stretch Screens • Triangular Decor Scrims • Decor Display Panels[/TD]
</tbody>
[TD]
<tbody>
[TD="class: xl65, align: center"]#VALUE![/TD]
</tbody>
[/TR]
[TR]
[TD]
| • Sleek All Black Stealth Frame and Scrim Design • Super Lightweight Powder Coated Aluminum Frame Construction • Detachable Pin-Hinged Sections for Easy Assembling and Disassembling • Includes Four 24"W x 46"H Sections • Each Section Color Code Marked For a Quick Setup • Carrying/Storage Bag is Included: (25" x 46.75" x 4.25") *use all necessary safety precautions when using heat and electrical related devices near the stretch screen **SCRIM CLEANING CARE: Dry-Clean or Machine wash in cold water (Do not bleach). Hang dry or Tumble dry at "low" to no heat. Do not iron. *Flame retardant must be retreated after washing or dry-cleaning. Other Related Products • SWF7246BLK 72"W x 46"H All Black Pro DJ Facade ALL WHITE PRO DJ FACADES • SWF4846WHT 48"W x 46"H All White Pro DJ Facade • SWF7246WHT 72"W x 46"H All White Pro DJ Facade BLACK FRAME WITH WHITE SCRIM PRO DJ FACADES • SWF4846B 48"W x 46"H Pro DJ Facade • SWF7246B 72"W x 46"H Pro DJ Facade • SWF9646B 96"W x 46"H Pro DJ Facade • SWFTT5816B 58"W x 16"H Table Top Pro DJ Facade OTHER SCRIM WERKS™ PRODUCTS • Light Columns • 12"x12" Square Truss Slip Screens™ Stretch Covers • Banquet Table Slip Screens™ Stretch Covers • Lighting/Speaker Tripod/Crank Stand Stretch Covers • X Stand Slip Screen™ Stretch Covers • Video Stretch Screens • Triangular Decor Scrims • Decor Display Panels |
<tbody>
</tbody>
[TD]
<tbody>
[TD="class: xl65"]Sleek All Black Stealth Frame and Scrim Design[/TD]
</tbody>
[/TR]
</tbody>[/TABLE]
Here is an online workbook with the example. https://1drv.ms/x/s!Avza4YgA-BnDjBwMZ6nL1YudMvzq
