Forum home » Delegate support and help forum » Microsoft Excel Training and help » Trimming text charatcers from cells in Excel

Trimming text charatcers from cells in Excel

ResolvedVersion 2003

Wed 16 Apr 2008, 16:37 Delegate Sheila said...

Sheila has attended:
Excel Advanced course

Trimming text charatcers from cells in Excel

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

Thu 17 Apr 2008, 08:14 Edited on Thu 17 Apr 2008, 08:15 Trainer Pete said...

RE: Trimming text charatcers from cells in Excel

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

Thu 17 Apr 2008, 16:35 Delegate Sheila said...

RE: Trimming text charatcers from cells in Excel

Brilliant!

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

Regards Sheila

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Trimming text charatcers from cells in Excel

Trimming text charatcers from cells in Excel

RE: Trimming text charatcers from cells in Excel

RE: Trimming text charatcers from cells in Excel

Excel articles

Excel tip:

Convert Text into Number