Trimming text charatcers from cells in Excel

The UK's most regular instructor-led training courses.
Training information: excel-training-course · Excel training course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Sheila has attended:
Excel Advanced course

by - delegate Sheila [4 posts] (2008 Apr 16 Wed, 16:37) Reply

How could I trim say 12 characters from the right of a cell in Excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	6	book now	£214	£230
2003	2008 Sep 17 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 126 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Trimming text charatcers from cells in Excel

by - trainer Pete platinum contributer [799 posts] (2008 Apr 17 Thu, 08:14) Edited on 2008 Apr 17 Thu, 08:15 Reply

Hi Sheila, Thank you for your post, welcome to the forum, in your case if you wish to trim these characters from the right of cell A1 then use this formula; =RIGHT(A1, LEN(A1)-12)
to trim from the left substitute LEFT the length to trim will be the final number in this case -12, I hope that helps, best regards Pete

RE: Trimming text charatcers from cells in Excel

by - delegate Sheila [4 posts] (2008 Apr 17 Thu, 16:35) Reply

Brilliant!

Many thanks, that is very helpful. This forum is going to be sooooo useful!

Regards Sheila

· Compare Different MS Excel Training Methods
· Crazy Things People Have Done With Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Microsoft Excel Training: Not Just for Newbies Anymore
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Please browse our web site to find out more about
excel-training-course and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips