Forum Discussion

rangelsammon's avatar
rangelsammon
Brass Contributor
Dec 10, 2022
Solved

Textbefore / after dillimeter with ranges

Book1.xlsx

 

I cant seem to get this to work. See work book that textbefore after doesnt allow ranges in the dillimeter. anyone get that to work?

excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Dec 10, 2022

    Hi rangelsammon 

     

     

    in C1:

    =MAP(A1:A4,B1:B4,
    LAMBDA(string,delim, TEXTAFTER(string,delim))
)

     

    • rangelsammon's avatar
      rangelsammon
      Brass Contributor
      Dec 12, 2022
      THANK YOU! i am reading more into map and lambda. can i substitute A1:A4 for A1#? i tried but not working

Resources