Hi
I have some strings in a column which will have prefix / suffix added later in the column.
Search should find the latest string in a text from Bottom and return the value.
Please suggest the formula. Attaching the example
Hi
I have some strings in a column which will have prefix / suffix added later in the column.
Search should find the latest string in a text from Bottom and return the value.
Please suggest the formula. Attaching the example
Shan
Hi,
According to your description and sample, this formula in J5 copied down:
Formula:Please Login or Register to view this content.
See attached.
as above but just illustrating approach of utilising the numeric return of Search
Formula:Please Login or Register to view this content.
Works like a charm .. Thank you both.. I am marking this request as resolved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks