Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help with transferring middle part of a cell entry
This is I'm sure a simple formula, I have a cell entry which is like
13543/t125790/INT This represents 3 different pieces of data, I have used left and right formulas to get the beinning and end of the entry into two separate cells, I now need to get the middle entry T125790 into a cell of it's own. How do I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help with transferring middle part of a cell entry
Hi Paula
Try =MID(A1,FIND("/",A1)+1,FIND("^",SUBSTITUTE(A1,"/","^",2))-1-FIND("/",A1)) -- Regards Roger Govier "Paula" wrote in message ... This is I'm sure a simple formula, I have a cell entry which is like 13543/t125790/INT This represents 3 different pieces of data, I have used left and right formulas to get the beinning and end of the entry into two separate cells, I now need to get the middle entry T125790 into a cell of it's own. How do I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help with transferring middle part of a cell entry
"Paula" wrote in message
... This is I'm sure a simple formula, I have a cell entry which is like 13543/t125790/INT This represents 3 different pieces of data, I have used left and right formulas to get the beinning and end of the entry into two separate cells, I now need to get the middle entry T125790 into a cell of it's own. How do I do this? There are different ways, depending on how flexible it needs to be. If the number of characters in each 'piece of data' is fixed (at 5, 7 and 3 in your example), you can use =MID(A1,7,7) If this varies, but you have already extracted the left piece into B1 and the right piece into C1, you can use =MID(A1,LEN(B1)+2,LEN(A1)-LEN(B1)-LEN(C1)-2) Do either of these meet your needs? Stephen |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help with transferring middle part of a cell entry
Hi Roger,Stephen,
Thanks for your replies, both of your formulas got the result I needed. Many thanks Paula "Stephen" wrote: "Paula" wrote in message ... This is I'm sure a simple formula, I have a cell entry which is like 13543/t125790/INT This represents 3 different pieces of data, I have used left and right formulas to get the beinning and end of the entry into two separate cells, I now need to get the middle entry T125790 into a cell of it's own. How do I do this? There are different ways, depending on how flexible it needs to be. If the number of characters in each 'piece of data' is fixed (at 5, 7 and 3 in your example), you can use =MID(A1,7,7) If this varies, but you have already extracted the left piece into B1 and the right piece into C1, you can use =MID(A1,LEN(B1)+2,LEN(A1)-LEN(B1)-LEN(C1)-2) Do either of these meet your needs? Stephen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract just numeric part of mixed text/number entry? | Excel Worksheet Functions | |||
function to count the amount of cells depending on part of the cell entry | Excel Worksheet Functions | |||
matching part of an entry in a cell | Excel Worksheet Functions | |||
Thanks everybody for help! How to delite a part of entry for a col | Excel Discussion (Misc queries) | |||
How do I work with part of a cell entry? | Excel Worksheet Functions |