find and replace

%3CLINGO-SUB%20id%3D%22lingo-sub-1791607%22%20slang%3D%22en-US%22%3Efind%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1791607%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20remove%20the%20names%20and%20leave%20the%20code%20on%20this%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22129%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22129%22%3EVAN073%20-%20VANERON%20INCORPORATED%20LTD%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVAN082%20-%20Westal%20Trust%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVAN455%20-%20VAN%20DER%20WESTHUIZEN%26nbsp%3B%20SARIE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVAN500%20-%20VAN%20DER%20MERWE%26nbsp%3B%20MANDA%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVAS005%20-%20SOPHIA'S%20ROSES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVEL010%20-%20VELDSMAN%26nbsp%3B%20DR%20MARLENE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVER020%20-%20VERBISPACE%20PTY%20Ltd%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVER029%20-%20VERMEULEN%26nbsp%3B%20J%20L%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVIC005%20-%20VICKERY%20SEEDLING%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVIL029%20-%20VILJOEN%26nbsp%3B%20JENNY%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVIS030%20-%20NEMERIA%20INVESTMENT%20(PTY)%20LTD%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVRE022%20-%20VAN%20RENSBURG%26nbsp%3B%20TANIA%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWEB001%20-%20WEBSITE%20ORDER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWEL001%20-%20WELSFORD%26nbsp%3B%20M%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWHI016%20-%20WHITE%20RIVER%20GARDEN%20PAVILION%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWIL058%20-%20WILLOW%20FEATHER%20FARMING%26nbsp%3B%20ENTERPRISES%20cc%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWIL065%20-%20WILLIAMS%26nbsp%3B%20WINSTON%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EZEE006%20-%20ZEEMAN%26nbsp%3B%20MELISSA%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EZEZ001%20-%20ZEZET%20PLANT%20ROSES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EZTEA01%20-%20THE%20ROSE%20KITCHEN%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796920%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835783%22%20target%3D%22_blank%22%3E%40Johannse_Shikwe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20the%20column.%3C%2FP%3E%0A%3CP%3EOn%20the%20Data%20tab%20of%20the%20ribbon%2C%20click%20Text%20to%20Columns.%3C%2FP%3E%0A%3CP%3EIn%20Step%201%2C%20select%20Fixed%2C%20then%20click%20Next%20%26gt%3B.%3C%2FP%3E%0A%3CP%3EIn%20Step%202%2C%20drag%20a%20vertical%20line%20to%20immediately%20after%20the%20codes%2C%20and%20remove%20the%20other%20lines%20by%20double-clicking%20on%20them.%20Then%20click%20Next%20%26gt%3B.%3C%2FP%3E%0A%3CP%3EIn%20Step%203%2C%20click%20on%20the%20second%20column%2C%20then%20select%20'Do%20not%20import%20column%20(skip).%3C%2FP%3E%0A%3CP%3EClick%20Finish.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Good Day.

 

I want to remove the names and leave the code on this column.

 

VAN073 - VANERON INCORPORATED LTD
VAN082 - Westal Trust
VAN455 - VAN DER WESTHUIZEN  SARIE
VAN500 - VAN DER MERWE  MANDA
VAS005 - SOPHIA'S ROSES
VEL010 - VELDSMAN  DR MARLENE
VER020 - VERBISPACE PTY Ltd
VER029 - VERMEULEN  J L
VIC005 - VICKERY SEEDLING
VIL029 - VILJOEN  JENNY
VIS030 - NEMERIA INVESTMENT (PTY) LTD
VRE022 - VAN RENSBURG  TANIA
WEB001 - WEBSITE ORDER
WEL001 - WELSFORD  M
WHI016 - WHITE RIVER GARDEN PAVILION
WIL058 - WILLOW FEATHER FARMING  ENTERPRISES cc
WIL065 - WILLIAMS  WINSTON
ZEE006 - ZEEMAN  MELISSA
ZEZ001 - ZEZET PLANT ROSES
ZTEA01 - THE ROSE KITCHEN
1 Reply
Highlighted

@Johannse_Shikwe 

Select the column.

On the Data tab of the ribbon, click Text to Columns.

In Step 1, select Fixed, then click Next >.

In Step 2, drag a vertical line to immediately after the codes, and remove the other lines by double-clicking on them. Then click Next >.

In Step 3, click on the second column, then select 'Do not import column (skip).

Click Finish.