| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
selective text
Hi i have a text string of 17 characters and I would like to only select the
the first six characters starting on the right hand side eg MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks -- Eager to learn ! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
selective text
With your text in cell A1 try the below formula
=RIGHT(A1,7) to convert to a number =--RIGHT(A1,7) If this post helps click Yes --------------- Jacob Skaria "Graham" wrote: Hi i have a text string of 17 characters and I would like to only select the the first six characters starting on the right hand side eg MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks -- Eager to learn ! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
selective text
Small correction to Jacob's formulas.... the 7's should be a 6's.
-- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... With your text in cell A1 try the below formula =RIGHT(A1,7) to convert to a number =--RIGHT(A1,7) If this post helps click Yes --------------- Jacob Skaria "Graham" wrote: Hi i have a text string of 17 characters and I would like to only select the the first six characters starting on the right hand side eg MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks -- Eager to learn ! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
selective text
Thanks Rick..
"Rick Rothstein" wrote: Small correction to Jacob's formulas.... the 7's should be a 6's. -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... With your text in cell A1 try the below formula =RIGHT(A1,7) to convert to a number =--RIGHT(A1,7) If this post helps click Yes --------------- Jacob Skaria "Graham" wrote: Hi i have a text string of 17 characters and I would like to only select the the first six characters starting on the right hand side eg MALAC53JJA1234567, i want to display 234567. Hope it can be done ,thanks -- Eager to learn ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selective on Name | Excel Discussion (Misc queries) | |||
| Can i format (colour) selective text in a cell using excel2000? | Excel Discussion (Misc queries) | |||
| Selective prodictive text | Excel Discussion (Misc queries) | |||
| Selective calculation | Excel Worksheet Functions | |||
| Selective deletion of rows containing certain text. | Excel Worksheet Functions | |||
Linear Mode
