SOLVED

# ** HELP ** Need to Join Text but also have superscript

Copper Contributor

# ** HELP ** Need to Join Text but also have superscript

Hi All,

@Hans Vogelaar / @Sergei Baklan

Wondering if you can help here and will walk you through what im trying to achieve

Step 1:

In Columns D, we have the name of a Feature/Product but i need to merge Column F then E with Column D but the content in Column F needs to be superscripted.

Step 2:

On tab Formulas, i would like to create XLookup/Filter/Search whereby it pulls through results based on the value of Column A, B & C on "Clean Tab" e.g If i wanted to see everything that was assigned to Global Platform > Launches >New Operators it would pull through the top 9 and so on Global Platform > Launches > New Operators etc etc again the challenge i have is i still need Columns F to be superscripted from Clean tab to be superscripted.

Step 3:

The objective is to essentially be able to pull these data from excel and easily insert into a PowerPoint document as such:

4 Replies

# Re: ** HELP ** Need to Join Text but also have superscript

That would be very complicated. Formulas cannot preserve the format of the cells they refer to, so superscript formatting will be lost.

# Re: ** HELP ** Need to Join Text but also have superscript

@Hans Vogelaar

Thanks for the speedy response Hans, understood about the superscript. Was worth an ask. Would you be able to help with joining the Columns D, F & E based on the values of A, B & C to create a filter/search?

best response confirmed by sbruk89 (Copper Contributor)
Solution

# Re: ** HELP ** Need to Join Text but also have superscript

Let's say you enter a value for columns A, B and C in A2, B2 and C2 on the Formulas sheet.

To return the matching values from D, F and E:

=FILTER(Clean!\$D\$2:\$D\$1000&" "&Clean!\$F\$2:\$F\$1000&" "&Clean!\$E\$2:\$E\$1000, (Clean!\$A\$2:\$A\$1000=A2)*(Clean!\$B\$2:\$B\$1000=B2)*(Clean!\$C\$2:\$C\$1000=C2), "")

# Re: ** HELP ** Need to Join Text but also have superscript

@Hans Vogelaar

Awesome thank you Hans. Just one final thing/question.

Similar request to before, can you help be write an expression that looks in Column A of "Sheet1" and then pulls through the values for each subsequent column that falls within lets say "launches" so i want New operators to be filled and then New Retail Partners etc

Again pulling Columns D, F & E from Tab "Clean"

1 best response

Accepted Solutions
best response confirmed by sbruk89 (Copper Contributor)
Solution

# Re: ** HELP ** Need to Join Text but also have superscript

Let's say you enter a value for columns A, B and C in A2, B2 and C2 on the Formulas sheet.

To return the matching values from D, F and E:

=FILTER(Clean!\$D\$2:\$D\$1000&" "&Clean!\$F\$2:\$F\$1000&" "&Clean!\$E\$2:\$E\$1000, (Clean!\$A\$2:\$A\$1000=A2)*(Clean!\$B\$2:\$B\$1000=B2)*(Clean!\$C\$2:\$C\$1000=C2), "")