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

singling out characters

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Singling out characters

Singling out characters

ResolvedVersion 2007

Tristan has attended:
Excel Intermediate course
Excel Advanced course

Singling out characters

how would i single out an individual character in a record? For example: ASUM2412 Iwould like to single out the 'm' and create a record called monthly?

RE: singling out characters

If the code is always the same number of characters and the character you want is always in the same place then you could try using the left and right formulas. For your example: =LEFT(G5,4) where G5 is "ASUM2412" which gives you "ASUM" and then in another column: =RIGHT(F5,1) where F5 is the result of the first formula. This gives you 'M'

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

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.09 secs.