Forum Discussion
find and replace
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
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.
