Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim with Country code leading
I have some cells with two charcters leading and those are generally the
country code. How can I parse those out the country code and space to just see the supplier name? For example: AU BBL DOWNHOLE TOOLS LTD MX PATRULLAS DE ALARMA DE TABASCO SG CANTEEN 11 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim with Country code leading
If you want to completely remove them...
Select the cells in question Goto the menu DataText to Columns Select Fixed widthNext In the Data preview area use your mouse and double click where you want the data separated. If Excel has already guessed and inserted separators just double click on them to remove them. Based on your description you want to insert a separator after the 3rd character. After you have inserted the separator click Next In the next step of the wizard the data you want to strip out should be highlighted. Select Do not import column (skip). Click Finish -- Biff Microsoft Excel MVP "Cassius" wrote in message ... I have some cells with two charcters leading and those are generally the country code. How can I parse those out the country code and space to just see the supplier name? For example: AU BBL DOWNHOLE TOOLS LTD MX PATRULLAS DE ALARMA DE TABASCO SG CANTEEN 11 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim with Country code leading
Try
=MID(A1,FIND(" ",A1)+1,LEN(A1)) If this post helps click Yes --------------- Jacob Skaria "Cassius" wrote: I have some cells with two charcters leading and those are generally the country code. How can I parse those out the country code and space to just see the supplier name? For example: AU BBL DOWNHOLE TOOLS LTD MX PATRULLAS DE ALARMA DE TABASCO SG CANTEEN 11 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim with Country code leading
Hi,
Since the country code is 2 characters and a space is one than =MID(A1,4,9^3) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Cassius" wrote: I have some cells with two charcters leading and those are generally the country code. How can I parse those out the country code and space to just see the supplier name? For example: AU BBL DOWNHOLE TOOLS LTD MX PATRULLAS DE ALARMA DE TABASCO SG CANTEEN 11 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
typing 'Up Country' ends up as Up Country' ? | Excel Discussion (Misc queries) | |||
Trim Leading Spaces | Excel Worksheet Functions | |||
trim leading spaces | Excel Discussion (Misc queries) | |||
Code for Trim function | Excel Discussion (Misc queries) | |||
Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) |