Skip to Content

Section Word(s) out

Looking to capture group of words where it starts with ?

Example

Row 1 :There is ? Moon lighting day. I need only Moon lighting day.

Row 2 : where are u?Now. I need Now

Kindly assist

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 06, 2017 at 08:29 AM

    try this.

    =Substr([your object];Pos([your object];"?")+1;Length([your object]))

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 06, 2017 at 06:35 PM

    Hi Amit,

    Thanks works!

    How do l reference blank? If an object is blank, then..

    I tried if([object] = " "; blue; other condition

    I didnt get anything. Kindly help. Appreciate!

    Add comment
    10|10000 characters needed characters exceeded