re-writing value of a cell

[lab_harts]

hi, good day/afternoon/evening....

supposed, i have the following conditions:

a = ɐ
b = q
c = ɔ
d = p ('just an upside-down font actually)

if i enter a value in A1, let's "Hello world,I need help", i'm hoping to get an output of "Hǝllo ʍoɹlp,I ueǝd ɥelp"

in B1......just to be clearer, the text is "alternating" - proper>upsidedown>proper>upsidedown, and so forth.

thanks in advance.

[Kyle123]

What's the upside down font name?

[lab_harts]

hi, thanks for the reply....i don't have any upsidedown font...actually, i've just converted it from some on-line" text generator....and i've created a table like this:
a1 b1
a = ɐ
b = q
c = ɔ
d = p...up to z

my "basic" idea is to "extract" each letter first, and "alternatingly" replace each letter (2nd, 4th, 6th, etc) with the value from the table...and then combining them again to get the final output that i want....

[Kyle123]

Sorry I'm totally confused now. Can you upload your workbook?

It should have what you have currently done and a mock up of what you would like it to achieve.

[lab_harts]

excel.JPG


....almost done...the only problem I have right now is that I always get #N/A at the end of each line...here's a part the code.

=IF((MID($A1,COLUMN(T1),1))<>" ",(VLOOKUP((MID($A1,COLUMN(T1),1)),table!$A$2:$B$28,2,FALSE)), "")

[Kyle123]

Hi, an image isn't a workbook, please can you upload your workbook

[zbor]

Try:

=LOOKUP(REPT("Z",255), CHOOSE({1,2},"", IF((MID($A1,COLUMN(T1),1))<>" ",(VLOOKUP((MID($A1,COLUMN(T1),1)),table!$A$2:$B$28,2,FALSE)), "")))

[martindwilson]

somewhat more straight forward try

=IF(COLUMN(A1)>LEN($A$1),"",VLOOKUP((MID($A1,COLUMN(A1),1)),table!$A$2:$B$28,2,FALSE))

[lab_harts]

zbor...THAT WORKED! ...thank you so much!......kyle & martin, thanks for your time too...have a great life.

[martindwilson]

always glad to see ,don't understand tho, hard to see without work book

[Cutter]

Hello lab_harts, and welcome to the forum. Based on your last post I'll mark your thread as SOLVED. Please keep in mind for all future threads that you are required to do that yourself. Thanks.

Also, as a new member, you may not know that you can thank those who help you by clicking the small star icon in the lower left corner of the post in which the help is given. By doing so you can add to the reputation(s) of those who helped.

Here's how to mark a thread as SOLVED:

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save