find and replace

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

@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.