Hi,
Is there a formula that can look to see if there is a space in the data in a cell and if there is not, insert a space 3 digits from the end.
So the postcodes TA1 2BN and LS12 8PO would be left as they are and TA12BN and LS128PO would become TA1 2BN and LS12 8PO?
So the table would end up like this:
<tbody>
</tbody>
Kind Regards
Steven
<tbody>
</tbody>
Is there a formula that can look to see if there is a space in the data in a cell and if there is not, insert a space 3 digits from the end.
So the postcodes TA1 2BN and LS12 8PO would be left as they are and TA12BN and LS128PO would become TA1 2BN and LS12 8PO?
So the table would end up like this:
Data | Formula |
TA1 2BN | TA1 2BN |
LS12 8PO | LS12 8PO |
TA12BN | TA1 2BN |
LS128PO | LS12 8PO |
<tbody>
</tbody>
Kind Regards
Steven
<tbody>
</tbody>