View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default Need to pull a selected segment of numbers/text from a large strin

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


"Kidsimba" wrote:

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!