|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 12th, 2006, 03:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to remove a suffix in excel
type I have the following example data in cells and need to separate the
suffix. Adelphi Blue7 The suffix may be alpha or numerical but in all cases there is no space between the main text and the suffix. 
|
|
#2
February 12th, 2006, 03:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove a suffix in excel
Is the suffix always exactly one character?
If yes: =LEFT(A1,LEN(A1)-1) -- Gary's Student "BC" wrote: type I have the following example data in cells and need to separate the suffix. Adelphi Blue7 The suffix may be alpha or numerical but in all cases there is no space between the main text and the suffix.
|
|
#3
February 13th, 2006, 10:36 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove a suffix in excel
No, sometimes it's two but never more than that.
"Gary''s Student" wrote: Is the suffix always exactly one character? If yes: =LEFT(A1,LEN(A1)-1) -- Gary's Student "BC" wrote: type I have the following example data in cells and need to separate the suffix. Adelphi Blue7 The suffix may be alpha or numerical but in all cases there is no space between the main text and the suffix.
|
|
#4
February 13th, 2006, 10:41 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to remove a suffix in excel
and I also need to use the suffix i.e. put Adelphi Blue in one cell/column
and the suffix in another "BC" wrote: Community Message Not Available
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| unhide menu bar in excel - just disappeared | Sean | Setting up and Configuration | 11 | December 4th, 2005 08:01 PM |
| suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
| Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
Linear Mode
