Extracting 1 character from a position from the right of a string

[Trinity_UTT]

Hello

I have a question that I have been searching google for hours.

In cell B6 I have a binary code. (for example 01000001000 or 110)
On the right side I have a table that I need to then extract that data from Right to left.
Table.png

I need Bit 0 to have the 1st digit from the right
Bit 1 needs to have the 2nd digit from the right
Bit 2 needs to have the 3rd digit from the right

I tried to use =Right Function but it isn't specific for for the position from right just number of characters to include

Any ideas?

Thanks

[JohnTopley]

See yellow banner at top of of how to post a sample file.

[WideBoyDixon]

Assuming that cell under the heading "Bit15" is C6, try this in that cell then copy over to R6:

Please Login or Register  to view this content.

WBD

[AliGW]

Try this under Bit15 and copy across:

=MID($A1,COLUMNS(A:$O),1)

assuming your binary string is in A1.

[Pete_UK]

Another way - this is for Bit15:

=IF(LEN($B$6)<=(16-COLUMNS($B:B)),"",MID($B$6,LEN($B$6)-(16-COLUMNS($B:B)),1))

then copy across. It shows blanks for any binary digits which are larger than B6.

Hope this helps.

Pete

[Trinity_UTT]

This worked Perfectly!
Thank you so much

[AliGW]

Which of us are you addressing? You were offered three solutions.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Trinity_UTT]

Assuming that cell under the heading "Bit15" is C6, try this in that cell then copy over to R6:

Please Login or Register  to view this content.

WBD

This was the one I tried 1st that worked

I did try and quote it but failed

Regards

[AliGW]

So what about the rest of us? I think it would be polite to thank everyone who offered help, don't you?

[WideBoyDixon]

Actually, since you're on O365, you could just put this in C6:

Please Login or Register  to view this content.

That would fill in the rest of the row automatically since it would "spill".

WBD