| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the 6th thru the nth character?
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? -- HBF ------------------------------------------------------------------------ HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019 View this thread: http://www.excelforum.com/showthread...hreadid=554277 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return the 6th thru the nth character?
HBF =RIGHT(cell,5) Beege "HBF" wrote in message ... 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? -- HBF ------------------------------------------------------------------------ HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019 View this thread: http://www.excelforum.com/showthread...hreadid=554277 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return the 6th thru the nth character?
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return the 6th thru the nth character?
Try...
=REPLACE(A2,1,FIND(".",A2),"") Hope this helps! In article , HBF wrote: 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return the 6th thru the nth character?
Sorry, misunderstood OP
Beege "Beege" wrote in message ... HBF =RIGHT(cell,5) Beege "HBF" wrote in message ... 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? -- HBF ------------------------------------------------------------------------ HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019 View this thread: http://www.excelforum.com/showthread...hreadid=554277 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return the 6th thru the nth character?
=MID(A1,6,999) "Beege" wrote in message ... HBF =RIGHT(cell,5) Beege "HBF" wrote in message ... 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? -- HBF ------------------------------------------------------------------------ HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019 View this thread: http://www.excelforum.com/showthread...hreadid=554277 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
