Align Text on a Specific Character

[SledLax]

Hi.

I want to align the text in a column so that a specific character (±) is in the centre. The number of characters either side will vary depending on the value, # decimal places etc, but the one constant will be the ± character.

This is an example of some data:

<colgroup><col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> </colgroup><tbody>
[TD="class: xl64, width: 96"]

<colgroup><col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> </colgroup><tbody>
[TD="class: xl66, width: 96"]44:37 ± 4:01 ^c
[/TD]

[TD="class: xl67"]73 ± 11[/TD]

[TD="class: xl67"]1.6 ± 0.3 ^c [/TD]

[TD="class: xl67"]7.12 ± 2.40 ^b
[/TD]

</tbody>

[/TD]

[TD="class: xl65"]Thanks.[/TD]

[TD="class: xl66"][/TD]

</tbody>

 

[SledLax]

Thanks Everyone for your assistance. I now have a very simple/elegant solution (separate columns) and also the automated process (macro) I was looking for. I appreciate your help.

 

[DanteAmor]

Thanks Everyone for your assistance. I now have a very simple/elegant solution (separate columns) and also the automated process (macro) I was looking for. I appreciate your help.

I'm glad to help you. Thanks for the feedback.