Return the 6th thru the nth character?

H

HBF

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
 
F

Franz Verga

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?
Click to expand...

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
 
Top