Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
Could you suggest a formula to look at a cell containing twenty characters
and display only the last five in a given cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
=right(A1,5) assuming your text is in cell A1 -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=561668 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
if you want to extract last five characters of that cell which exactly contains twenty characters then use the following function (if your data starts from A1 downwards) put in B1 =IF(LEN(A1)=20,RIGHT(A1,5),"") this will return last five characters if the cell contains exactly 20 characters in it otherwise it will return blank cell. if you want to extract last five characters regardless of the number of characters in the cell then use the following fuctions. =RIGHT(A1,5) hope this could serve your purpose. sdmccabe Wrote: Could you suggest a formula to look at a cell containing twenty characters and display only the last five in a given cell? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=561668 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |