How to extract text from column that got text

Manjit - Updated on Jan 21, 2022 at 11:55 PM
PhumeleleToniJose
Posts
2
Registration date
Sunday January 9, 2022
Status
Member
Last seen
February 1, 2022
- Jan 25, 2022 at 02:47 AM
Hello,
I would like help on how to extract text from column which has text. Some column might not have text or blank, want to know how to extract this type of column that got text and arrange it in another sheet?


System Configuration: Windows / Chrome 97.0.4692.99

1 reply

PhumeleleToniJose
Posts
2
Registration date
Sunday January 9, 2022
Status
Member
Last seen
February 1, 2022

Jan 25, 2022 at 02:47 AM
Split columns with SPLIT():
1. Create at least two columns next to the column with the data you want to split. You can do so, click on the header (A, B, C, etc.). Then click the little triangle and select “Insert 1 right”. Repeat to create a second free column.
2. In the first free column, write =SPLIT(B1,"-"), with B1 being the cell you want to split and - the character you want the cell to split on. (If you see the error #REF! in your cell, you’ll need to create more columns.)
3. To apply the changes to the cells below, drag down the blue square in the bottom right of the selected cell(s). Double-click on the blue square to fill all remaining cells.

Extract content from columns with LEFT():
1. Insert a new column. (Or two. Or three! As many as you need.)
2. In the new column(s), write
=LEFT(B1,2) to extract the first 2 characters of the cell B1.
=RIGHT(B1,8) to extract the last 8 characters of the cell B1.
=MID(B1,4,2) to extract the 2 characters following the 4th character in B1.
3. To apply the changes to the cells below, drag down the blue square.
0