Good day Demigods,
Sheet 1, cell A1 contains alphanumeric user entered data and is referenced on ten other sheets.
Some users enter data as
Others enter data as, for example,
I'm not bothered how it looks on Sheet 1, cell A1, but for the other worksheets, I want the data the user has entered to be displayed as
I can trim the excess spaces, but don't know how to add the comma.
Any help/comments greatly appreciated, as usual.
Best Regards
manc
Sheet 1, cell A1 contains alphanumeric user entered data and is referenced on ten other sheets.
Some users enter data as
,"E022563, E055634, E074596"
Others enter data as, for example,
- curse them!"E002563", then 5 spaces, "E055634", then 4 spaces, "E074596"
I'm not bothered how it looks on Sheet 1, cell A1, but for the other worksheets, I want the data the user has entered to be displayed as
- one comma followed by a space."E022563, E055634, E074596"
I can trim the excess spaces, but don't know how to add the comma.
Any help/comments greatly appreciated, as usual.
Best Regards
manc
Last edited: