98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Singling out characters
Singling out characters
Resolved · Low Priority · Version 2007
Wed 14 May 2008, 15:53Delegate Tristan said...
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?
Thu 15 May 2008, 20:13Trainer Rich said...
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'
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |
