How to extract text from column that got text

Closed
Manjit - Updated on Jan 21, 2022 at 11:55 PM
Jameswalter2050 Posts 6 Registration date Saturday August 27, 2022 Status Member Last seen September 20, 2022 - Aug 27, 2022 at 03:52 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

2 replies

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
Jameswalter2050 Posts 6 Registration date Saturday August 27, 2022 Status Member Last seen September 20, 2022
Aug 27, 2022 at 03:52 AM

Select the cells that you want to extract characters, click Kutools > Text > Extract Text. 2. In the popping Extract Text dialog, under Extract by location tab, go to the before the text and after the text options to specify the setting as you need.. Before the text: extract substrings before the entered character (s).

Greeting,
James

0