ExcelBanter - enter formula to copy characters in a cell less last one

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - enter formula to copy characters in a cell less last one (https://www.excelbanter.com/excel-discussion-misc-queries/81684-enter-formula-copy-characters-cell-less-last-one.html)

BC@D

enter formula to copy characters in a cell less last one

Bryan Hessey

enter formula to copy characters in a cell less last one

=left(a1,len(a1)-1)

bc@d Wrote:

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=530171

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