Hello,
I need help trying to use a formula that will select certain text within a text and combine with another column. Please see attached example
Hello,
I need help trying to use a formula that will select certain text within a text and combine with another column. Please see attached example
You need to give more explanation about the logic being applied to each row. I can't easily see a consistent pattern.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Olly,
I am trying to pull specific information from the text column "C" but the data that i am working with is very inconsistent. There's 3 types of data that i have here
ADA
Merch
and then all other.
a) for ADA I just need it to show : ADA and the date after STMT with the description before "_"
b) for merch i just needit to show : MerchNow date and the description
c) allother its set up as follows:
MNT or GRO then Company Name Invoice# and description I want to eliminiate the MNT/GRO and pick the company name invoice number and select the description on column D.
i have the examples set up on column F as to what I want to show. Thanks
Which Excel version are you using? Your profile says 2003, but your attachment is 2007+...
excel 2016
Please update your user profile to reflect this.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks