ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Keep specified number of characters at end of cell? (https://www.excelbanter.com/excel-worksheet-functions/151058-keep-specified-number-characters-end-cell.html)

Kevin

Keep specified number of characters at end of cell?
 
I am trying to keep 6 characters at the end of a random length of characters
in a cell. I know how to delete a specific number of characters etc.

bj

Keep specified number of characters at end of cell?
 
if they are text try
=right(A1,6)


"Kevin" wrote:

I am trying to keep 6 characters at the end of a random length of characters
in a cell. I know how to delete a specific number of characters etc.



All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com