Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : Quik way of getting customer name
Dear Sir,
I have a block of Credit Note reference and customer name separated by - as illustrated A B FAF CN NK000156 SUMISO S/B (PJVM) SUMISO S/B (PJVM) FAF CN NK000133 - PANASONIC PANASONIC FAF CN NK000154 - ATAMA LOGISTIC ATAMA LOGISTIC FAF CN NK000158 - DNE LOGISTICS S/B DNE LOGISTICS S/B FAF CN NK000155 - KUMISU YUKU SDN BHD KUMISU YUKU SDN BHD May I know If there is a quick way of getting the full customer name just behind the - as an output in columm B ? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : Quik way of getting customer name
Sub finddash()
For Each c In Range("a17:a21") x = InStr(c, "-") + 1 MsgBox x c.Offset(, 1) = Right(c, Len(c) - x) Next End Sub Or if ALWAYS 17 use that instead Sub finddash1() For Each c In Range("a17:a21") c.Offset(, 1) = Right(c, Len(c) - 18) Next End Sub -- Don Guillett SalesAid Software "Mr. Low" wrote in message ... Dear Sir, I have a block of Credit Note reference and customer name separated by - as illustrated A B FAF CN NK000156 SUMISO S/B (PJVM) SUMISO S/B (PJVM) FAF CN NK000133 - PANASONIC PANASONIC FAF CN NK000154 - ATAMA LOGISTIC ATAMA LOGISTIC FAF CN NK000158 - DNE LOGISTICS S/B DNE LOGISTICS S/B FAF CN NK000155 - KUMISU YUKU SDN BHD KUMISU YUKU SDN BHD May I know If there is a quick way of getting the full customer name just behind the - as an output in columm B ? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
from Excel look up customer information on a website | Excel Worksheet Functions | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
How do I create a customer database in excel | Excel Discussion (Misc queries) | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) |