Parsing a string of data

[Penny]

I am trying to parse data from string but need to start
in a position other than the first postition from the
left or right. I want to read from on direction but need
to specify the starting position and then specify the
number of characters to read. Any input would be helpful.

 

[Bernie Deitrick]

Penny,

The MID function can be used to specify the starting location and length.
Beyond that, you'll need to post an example of what you have and what you
want.

HTH,
Bernie
MS Excel MVP

 

[Andy B]

Hi

Use the MID function:
=MID(cell,startpoint,number of characters)

 

[Dave R.]

Can you give an example of some strings, and where you want it parsed?

Sounds like you would use MID since you can specify the starting cell and
how many cells to read.

 

[Don Guillett]

Have a look in HELP index for SEARCH and/or FIND