ExcelBanter - Formula Needed - Truncate extra spaces at end of variable text len

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

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

- - Formula Needed - Truncate extra spaces at end of variable text len (https://www.excelbanter.com/excel-discussion-misc-queries/208935-formula-needed-truncate-extra-spaces-end-variable-text-len.html)

Roibn Taylor

Formula Needed - Truncate extra spaces at end of variable text len

Apollo Environmental Strategies
B&B Laboratories

The cells pasted above have variable blank spaces at the end. I need
spaces removed at the end of each cell using a formula.
--
Thanks for the help in advance

John C[_2_]

Formula Needed - Truncate extra spaces at end of variable text len

=TRIM(A1)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.

"Roibn Taylor" wrote:

Apollo Environmental Strategies
B&B Laboratories

The cells pasted above have variable blank spaces at the end. I need
spaces removed at the end of each cell using a formula.
--
Thanks for the help in advance

All times are GMT +1. The time now is 03:41 AM.