Hi All,
I am trying to create a formula to pull text from one cell into the next. I have attached a spreadsheet to explain in more detail:
Hi All,
I am trying to create a formula to pull text from one cell into the next. I have attached a spreadsheet to explain in more detail:
welcome to the forum. maybe something along:
=TRIM(MID(SUBSTITUTE($I4,CHAR(10),REPT(" ",LEN($I4))),SEARCH(K$3,SUBSTITUTE($I4,CHAR(10),REPT(" ",LEN($I4))))+LEN(K$3)+2,LEN($I4)))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
That has definitely done the trick! Thank you so much
Put this in K4:
=IF(ISNUMBER(SEARCH("Group",I4)),MID(I4,SEARCH("group",I4)+7,FIND(CHAR(10),I4,SEARCH("group",I4)+1)-SEARCH("group",I4)-7),"")
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks