Substitute Exact

[Cooki]

Hi All i want to be able to find an exact match when using substitute, not sure if possible.

I currently have the substitute formula working fine up until cell A10

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E5, A5, B5), A6, B6),A7,B7),A8,B8),A9,B9),A10,B10),A11,B11)

Ive tried building formula again but cant get it to work =SUBSTITUTE(EXACT(D12,A13),A13,B13)

But keep getting False

So need the formula to be able to see S5 and S55 as different and substitute for the cells in Column B

This is the issue when i just use substitute =SUBSTITUTE(D12,A13,B13)

Result

{0:454545}-{0:S3}-{0:4545455}

Need to the to be

{0:454545}-{0:S3}-{0:969696}

 

[Fluff]

If the value to be substituted always has a } after it, try
SUBSTITUTE(E5, A5&"}", B5&"}")

 

[Cooki]

If the value to be substituted always has a } after it, try
SUBSTITUTE(E5, A5&"}", B5&"}")

Very close but i still need the format to be the same

output using your formula is

{0:454545-{0:656565-{0:969696

Format needs to carry on like
{0:454545}-{0:S3}-{0:4545455}

Without me adding more } to accommodate for me using } in my substitute

If that makes sense

 

[Fluff]

Did you put the 2nd } as I showed
SUBSTITUTE(E5, A5&"}", B5&"}")

 

[Cooki]

Did you put the 2nd } as I showed
SUBSTITUTE(E5, A5&"}", B5&"}")

Opps............................

Maybe i missed that lol apologies

Perfect...... thank you, that will do the trick

 

[Fluff]

You're welcome & thanks for the feedback