ExcelBanter - Removing Text

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

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

- - Removing Text (https://www.excelbanter.com/excel-discussion-misc-queries/215367-removing-text.html)

Rob

Removing Text

Hi Everyone,

Problem - Im trying to remove the last two characters (Text) from each cell.

Example:
(A1)Expense Account
(A2)Robert Smith

Result Deisred:
(A1) Expense Accou
(A2) Robert Smi

Any help would be greatly appreciated.

Thanks!
Rob

Gary''s Student

Removing Text

=LEFT(A1,LEN(A1)-2)
this uses an extra cell to hold the formula
--
Gary''s Student - gsnu200823

"Rob" wrote:

Hi Everyone,

Problem - Im trying to remove the last two characters (Text) from each cell.

Example:
(A1)Expense Account
(A2)Robert Smith

Result Deisred:
(A1) Expense Accou
(A2) Robert Smi

Any help would be greatly appreciated.

Thanks!
Rob

All times are GMT +1. The time now is 09:54 AM.