L
Lee
Hi guys,
Can you advise me on how I can remove a single space from
the middle of a string? I have a large number of records
to import and many of them (but not all) have a space in
the middle of the field. For example:
3301TH
3301XH
3301 X
3301 T
The top two records are fine but the other two need to
read:
3301X
3301T
I can't see how to remove the space. Can you help?
Kind regards,
Lee
Can you advise me on how I can remove a single space from
the middle of a string? I have a large number of records
to import and many of them (but not all) have a space in
the middle of the field. For example:
3301TH
3301XH
3301 X
3301 T
The top two records are fine but the other two need to
read:
3301X
3301T
I can't see how to remove the space. Can you help?
Kind regards,
Lee