Parsing a string of data

  • Thread starter Thread starter Penny
  • Start date Start date
P

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.
 
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
 
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.
 
Back
Top