Hi everyone,
I cannot figure out how to do this cleaning...
In my row, some cells contain a single dash. And I want to remove it.
but other cells contain also a dash with other characters. And in that case, I need to keep the dash.
Example
-
RRR-1535
RRR 1242-U REUTLINGEN
RRA-NR. 19521
thank you for your help
Myriam
Solved! Go to Solution.
thanks BenMoss !
It works fine
Hello,
I'd like to inquire about a specific procedure. How can I modify characters within the data to display as empty cell instead of completely removing the data?
For example:
From | To |
# | |
#12-12 | #12-12 |
#Happy | #Happy |
Your guidance in achieving this is much appreciated.
Thank you.