To trim text means to reduce the number of words or phrases in a given text. Sometimes, you may need to extract text from a cell and use it in another cell. Thankfully, the feature of trimming text can be applied here. In this text, we shall discuss ways of trimming text from the left in Google Sheets and Excel.
To trim Text in Google Sheets
Table of Contents
Below are the methods that can be used to achieve this:
a) Using the Left function
Steps to follow:
1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).
2. From the Google Apps, click on the Sheets icon and select the existing Sheet.
3. Locate the dataset you want to trim.
4. Click on an empty cell, and type this function =LEFT (
5. Select the cell you want to trim, and add it to your formula. That is, LEFT (A2,
6. Then, add the numbers of characters you want to trim. That is =LEFT( A2, 4)
7. Finally, hit the Enter button.
b) Using the left and FIND function
Steps:
1. Locate the dataset you want to trim.
2. Click on an empty cell, and type this function =LEFT (
3. Select the cell you want to trim, and add it to your formula. That is, =LEFT (A2,
4. Next, add the FIND function. That is, =LEFT (A2,FIND(
5. Enter up to where you want to trim the text. For example, =LEFT (A2,FIND(” “,A2))
6. Finally, hit the Enter button.
c) Using the left and LEN function
Steps:
1. Locate the dataset you want to trim.
2. Click on an empty cell, and type this function =LEFT (
3. Select the cell you want to trim, and add it to your formula. That is, =LEFT (A2,
4. Next, add the LEN function. That is, =LEFT (A2,LEN(
5. Enter the numbers of characters you want to trim.For example, =LEFT (A2,LEN(A2)-numbers_of character-to_be _trimmed)
d) Using the Trim and Left function
Steps:
1. Locate the dataset you want to trim.
2. Click on an empty cell, and type this function =LEFT (
3. Next, add the LEFT function. That is, =TRIM(LEFT(A2,5)
4. Finally, hit the Enter button.
To trim Text in Excel.
Below are the methods that can be used to achieve this:
a) Using the Left function
Steps:
1. Open the Excel document and locate the dataset you want to trim.
2. Click on an empty cell, and type this function =LEFT (
3. Select the cell you want to trim, and add it to your formula. That is, LEFT (A2,
4. Then, add the numbers of characters you want to trim. That is =LEFT( A2, 4)
5. Finally, hit the Enter button.
b) Using the TRIM and LEFT function
Steps:
1. Open the Excel document and locate the dataset you want to trim.
2. Click on an empty cell, and type this function =LEFT (
3. Next, add the LEFT function. That is, =TRIM(LEFT(A2,5)
4. Finally, hit the Enter button.
c) Using the left and LEN function
Steps:
1. Locate the dataset you want to trim.
2. Click on an empty cell, and type this function =LEFT (
3. Select the cell you want to trim, and add it to your formula. That is, =LEFT (A2,
4. Next, add the LEN function. That is, =LEFT (A2,LEN(
5. Enter the numbers of characters you want to trim.For example, =LEFT (A2,LEN(A2)- numbers_of character-to_be _trimmed)