
A once-for-all (not dynamic) workaround:
=CONCATENATE("=";A1),

then menu Data - Text to Columns.

2 Likes

A once-for-all (not dynamic) workaround:
=CONCATENATE("=";A1),

then menu Data - Text to Columns.
