| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separate two words in cell
On sheet2 in cell a1 I have a number and name of a team which is: #1
Wonders. On sheet2 in cell a1, I would like a formula to give me the name of the team only (Wonders), without the number (#1). Thanks for your help. WallyB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separate two words in cell
Hi!
Try this: =MID(Sheet2!A1,FIND(" ",Sheet2!A1&" ")+1,255) Biff "wally" wrote in message ups.com... On sheet2 in cell a1 I have a number and name of a team which is: #1 Wonders. On sheet2 in cell a1, I would like a formula to give me the name of the team only (Wonders), without the number (#1). Thanks for your help. WallyB |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separate two words in cell
Biff wrote: Hi! Try this: =MID(Sheet2!A1,FIND(" ",Sheet2!A1&" ")+1,255) Biff "wally" wrote in message ups.com... On sheet2 in cell a1 I have a number and name of a team which is: #1 Wonders. On sheet2 in cell a1, I would like a formula to give me the name of the team only (Wonders), without the number (#1). Thanks for your help. WallyB Hi It works great, thank you very much WallyB |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separate two words in cell
You're welcome. Thanks for the feedback!
Biff "wally" wrote in message oups.com... Biff wrote: Hi! Try this: =MID(Sheet2!A1,FIND(" ",Sheet2!A1&" ")+1,255) Biff "wally" wrote in message ups.com... On sheet2 in cell a1 I have a number and name of a team which is: #1 Wonders. On sheet2 in cell a1, I would like a formula to give me the name of the team only (Wonders), without the number (#1). Thanks for your help. WallyB Hi It works great, thank you very much WallyB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| How Do? Take two words in cell 1 and slpit them to cell 2 & 3 | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Excel formula for seperating two words in the same cell. | New Users to Excel | |||
Linear Mode
