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:

44:37 ± 4:01c 73 ± 11 1.6 ± 0.3c 7.12 ± 2.40b <colgroup><col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> </colgroup><tbody> </tbody>

Thanks.

<colgroup><col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> </colgroup><tbody>
</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.