Remove whitespaces, line breaks, other chars & substrings from multiple Google Sheets cells

Remove substrings and characters in Google Sheets by position. Get Remove Text from the Google Sheets store:
https://workspace.google.com/marketplace/app/power_tools/1058867473888

Visit the help page for Remove Text:
https://www.ablebits.com/docs/google-sheets-remove-unwanted-characters/

Learn more about Power Tools and 30+ other add-ons on our website:
https://www.ablebits.com/google-sheets-add-ons/power-tools/index.php

00:04 Introduction to Remove Text
00:41 Start the Remove Text add-on
00:47 Remove substrings or characters
01:06 Remove spaces and delimiters
01:16 Remove characters by position
01:36 Wrap-up

👋 Let's be friends on socials!
LinkedIn: https://linkedin.com/company/apps4gs/
Facebook: https://www.facebook.com/ablebits/

#remove #googlesheets #spreadsheet #ablebits

---

Closed Caption:

Remove Text is
an add-on for Google Sheets
that removes substrings
from multiple cells in one go.
There are 3 main groups,
each with its own
set of data to delete.
The first will remove all instances
of any character
or even a particular text string.
The second one will remove
white spaces,
line breaks,
and some other delimiters.
The last one
will remove characters
from a certain position in cells;
from the beginning or the end of cells;
and before and after
a specific text string.
Let's remove some characters
directly in spreadsheets,
shall we?
You will find the Remove tool
in the Power Tools add-on,
Text Toolkit.
The first group removes those
substrings and characters
that you enter into one of
these corresponding fields.
For example,
I select the range,
and remove hashtags (#)
and At signs (@)
And also get rid of some word endings
to get their shortened
versions for addresses.
The second group deals with
a few specific characters.
For instance,
here I will trim all excess spaces
and remove all HTML tags.
Lastly,
I can remove characters by their position.
In my case, all 3 options will do:
I can set the exact position
and the number of symbols to remove,
or simply remove
the first 12 characters
or remove everything before
the line break,
which I'm going to do.
Install your Power Tools
from the Google Sheets store
to get Remove Text and over
30 other time-savers for spreadsheets.
If you have any questions,
feel free to leave a comment
or contact us directly.
We'll be happy to help!