Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to pull a selected segment of numbers/text from a large strin
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions |