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

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

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

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?

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

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