I have a quick Excel question for you guys, I'm doing some formatting for work, and I'm trying to come up with a quicker way to reformat the information into the format that we want. I've attached a sample section of what I'm working with to thisFunction Question.xlsxl. I'm trying to take the top section of text and make it look like the bottom section. I've tried playing around in Excel for a formula that would work, but I'm coming up dry. Any help would be appreciated, thank you!
Try:
=$A$2&" "&$A$3&" "&LEFT($A4,FIND(".",$A4)-1) =$A$2&" "&$A$3&" "&LEFT($A5,FIND(".",$A5)-1) =$A$2&" "&$A$3&" "&LEFT($A6,FIND(".",$A6)-1) =$A$2&" "&$A$3&" "&LEFT($A7,FIND(".",$A7)-1)
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...
Yes, that worked, thanks so much! Will going through 3500 lines so much easier!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks