cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philifova
Helper II
Helper II

Remove an Item in gallery

Hi Folks!

 

I have an items in my gallery for some reason there is a 4th row. How to remove this?

 

philifova_0-1669318025936.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
AmDev
Super User
Super User

Hi @philifova 

 

It looks like you potentially have a semi colon at the end of the strings you are trying to split. In this situation the split function will produce a blank row at the bottom of the result column to represent the right hand side of the last delimiter i.e. see below:

 

AmDev_1-1669319213921.png

 

 

To resolve you could use the Left and Len functions to remove the last ";" - see below example:

 

AmDev_2-1669319530106.png

 

Hope this helps 

View solution in original post

1 REPLY 1
AmDev
Super User
Super User

Hi @philifova 

 

It looks like you potentially have a semi colon at the end of the strings you are trying to split. In this situation the split function will produce a blank row at the bottom of the result column to represent the right hand side of the last delimiter i.e. see below:

 

AmDev_1-1669319213921.png

 

 

To resolve you could use the Left and Len functions to remove the last ";" - see below example:

 

AmDev_2-1669319530106.png

 

Hope this helps 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,547)