Return the 6th thru the nth character?

  • Thread starter Thread starter HBF
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP, a table with text and numerics 7
Creating a series of cells with multiple incrimenting characters 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Search and translate 2
How to extract text from middle of a string 18
How can I delete a space/character from a number of fields? 10
Extracting part of a cell 6
nth element extract 3

Back
Top