Copy part of a code within a cell

Sam Swain

Hello community!

I'm looking for a formula or workaround for capturing part of a code in a cell and copying it from another cell

In my contract number column I have 91B023047

I would like to copy B023 to another cell by somehow removing 91 and 047. Is this possible somehow?

ker9

Hi @Sam Swain ,

If the portion of the contract number you want always begins with the 3rd character and you always want 4 characters, this formula will pull that out:

=MID([Column3]@row, 3, 4)

Where [Column3] is your column name.

Hope this helps!

Anjanesh Vaidya

Hii Sam Swain,

You can try the below formula for the required condition:

=MID([Contact number]@row, 3, 4)

Thank You!

Anjanesh Vaidya