| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy only letters, not numbers
I have a huge long column of text---product codes, to be exact, that could
look something like this: CNUB275X3 or PB24X275. What I need is a formula, which I will put in the column beside this one, that will look at the code and put only the letters up to the first number. So, in this case it would put CNUB in the first row's cell and then PB for the next one. Is this possible? Connie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy first few letters from a cell | Excel Worksheet Functions | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Copy the first two or three letters of a cell to another one | Excel Discussion (Misc queries) | |||
| create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) | |||
| Letters = Numbers | Charts and Charting in Excel | |||
Threaded Mode
