Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

trimming text charatcers cells

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

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?

Edited on Thu 17 Apr 2008, 08:15

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

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.