New Posts For Thread: EXCEL QUESTION: Trimhttps://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trimManaged to kill a formula on an old spreadsheet and can't remember wording for TRIM() or is it another commandI want the following:No. 63 I WANT TO KEEP THISto be in another cell like this:I WANT TO KEEP THISNOTE: there are two spaces between 63 anlots more on my websitehttp://www.smashiton.com/Main/Computing.htm...https://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trim?post_id=484416697#484416697lots more on my websitehttp://www.smashiton.com/Main/Computing.htm...Wed, 02 Feb 2011 05:25:05 -0600both work...thank you.....Stow_judge, cheers for that link.https://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trim?post_id=484411021#484411021both work...thank you.....Stow_judge, cheers for that link.Wed, 02 Feb 2011 03:30:46 -0600...http://www.techonthenet.com/excel/formulas/index.php...https://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trim?post_id=484383065#484383065...http://www.techonthenet.com/excel/formulas/index.php...Tue, 01 Feb 2011 18:27:44 -0600=RIGHT(A22,(LEN(A22)-8))https://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trim?post_id=484382981#484382981=RIGHT(A22,(LEN(A22)-8))Tue, 01 Feb 2011 18:26:49 -0600Try ~=TRIM(MID(A22,8,LEN(A22)-7))https://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trim?post_id=484378225#484378225Try ~=TRIM(MID(A22,8,LEN(A22)-7))Tue, 01 Feb 2011 17:32:49 -0600For reply:A22 is:No. 63 I WANT TO KEEP THIShttps://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trim?post_id=484376109#484376109For reply:A22 is:No. 63 I WANT TO KEEP THISTue, 01 Feb 2011 17:10:18 -0600Managed to kill a formula on an old spreadsheet and can't remember wording for TRIM() or is it another commandI want the following:No. 63 I WANT TO KEEP THISto be in another cell like this:I WANT TO KEEP THISNOTE: there are two spaces between 63 anhttps://community.betfair.com/general_betting/go/thread/view/94082/26800021/excel-question-trim?post_id=484376005#484376005Managed to kill a formula on an old spreadsheet and can't remember wording for TRIM() or is it another commandI want the following:No. 63 I WANT TO KEEP THISto be in another cell like this:I WANT TO KEEP THISNOTE: there are two spaces between 63 anTue, 01 Feb 2011 17:09:14 -0600