Thursday 19 March 2020

Microsoft Excel - Formula to removed specified characters from string

Watch this example on YouTube




To Remove
=SUBSTITUTE(A1, "ABC", "")

To repalce with a space

=SUBSTITUTE(A1, "ABC", " ")
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)