| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy first few letters from a cell
Dear mate,
I have 6000 client names and some are duplicates. I need to copy just the first 5 letters of each client from the cell and place in the next cell. This will help me to sum up all the ABCDE revenue as they are all same client with different names with the first 5 letters are common. Hope I was able to explain my issue, For example ABCDE Ltd ABCDE co. ABCDE inc ABCDE ltee Regards Mat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| change lower letters to upper letters | Excel Discussion (Misc queries) | |||
| letters cut off in cell | Excel Worksheet Functions | |||
| Copy the first two or three letters of a cell to another one | Excel Discussion (Misc queries) | |||
Threaded Mode
