Need to pull a selected segment of numbers/text from a large strin

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 63 character long string that I need to pull several segemented
values from. i.e. I need the last 6 characters to go one cel, then characters
7-10 from the right to go into another cel, 11-18 to go into the next cel,
etc.
Is there a way to do this?

Thanks!
 
Yes, use the RIGHT, LEFT and MID functions.

=RIGHT(A1,6)

This will pull the last 6 characters from the string located in cell A1.

=MID(A1,7,4)

This will pull 4 characters out of the string in A1, starting with the 7th
character (7-10).

HTH,
Elkar
 

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

Need formulas to pull date and time from 1 cell to 2 6
Strip Character from Right 2
Pulling data from other worksheets 1
Counting number of occurrances 1
Reomving a set numer of characters from a text string 3
pulling certain characters from a string of text 3
Get address of found range to use in a formula 1
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT 11

Back
Top