How do I extract a part of a text string?

K

KMBarale

I am trying to extract a portion of a text string. I am able to determine
the starting and the ending position of the string but don't know what
command to use to extract those portions of the string, i.e. A1(10:15)???

Thank-you ... Kathy
 
I

icestationzbra

you have not provided a great deal of detail or information about you
query for anyone to provide you with the exact formulae.

you could use the LEFT, MID and RIGHT functions to extract portions o
a string. these could be used in conjunction with FIND and SEARCH t
provide the starting character position
 
M

mzehr

Hi',
I'm not real clear on what you're looking for, but perhaps the Mid()
function will help? A bit more detail with an example would be helpful
 

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

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Find date in excel string previous to last occurence of specific text 14
Extract Text in braquet and list of terms from 2 Docs 3
Select Text to End of Footnote 9
Extract name, address and ph# 8
Extract Month From A Text String 5
Extracting 7 digit number from alphanumeric string 11
HOW DO I EXTRACT NUMBERS FROM TEXT STRING 7

Top