Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Nel post
*HBF* ha scritto: I have data in cells that are formatted in a code.name format I need the name, but not the code - the code is always 5 characters. The name lenght is random. How do I get rid of the code and keep the name? If the format is really and always code.name with the code always of 5 characters, you have two way: 1) use the formula below =MID(A1,7,LEN(A1)-6) 2) menu Data, Text in columns and use the dot as separator for the columns. -- (I'm not sure of names of menues, option and commands, because translating from the Italian version of Excel...) Hope I helped you. Ciao Franz Verga from Italy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
want to return "n/a" or "0" | New Users to Excel | |||
If it's not a space, return the cell contents. | Excel Worksheet Functions | |||
Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions |