• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Below text i want to pull from formula the only text LIGT. i.e., from left.

akmaximo83

New Member
Dear All,

Below text i want to pull from formula the only text LIGT. i.e., from left.
Please for a general formula.
Route237 - LIGT02-M Maintenance of Emergency Lighting
 
can you attach a sample excel sheet - with expected results

left of LIGT is
Route237 -

is that what you want
=LEFT(A1,SEARCH("LIGT",A1,1)-1)
 

Attachments

  • left - etaf.xlsx
    9 KB · Views: 3
Dear All,

Below text i want to pull from formula the only text LIGT. i.e., from left.
Please for a general formula.
Route237 - LIGT02-M Maintenance of Emergency Lighting

Hello Akma

Here is the dynamic formula to extract the text "LIGT" from the given text, you can use the following formula:

Code:
=IFERROR(MID(A1, SEARCH(" - ", A1) + 3, SEARCH("-", A1, SEARCH(" - ", A1) + 3) - SEARCH(" - ", A1) - 3), "")

Assuming your text is in cell A1, this formula works by finding the position of the first " - " and then extracting the characters between that position and the next "-". It uses the `SEARCH` and `MID` functions.

Make sure to adjust the cell reference if your text is in a different cell. If you have different variations in your data, you might need to tweak the formula accordingly.
 
Back
Top