|
| 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
December 16th, 2005, 08:29 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
unrecognized character
I am trying to SEARCH or FIND a text string in an excel file without
any luck. The character is a hyphen (-) and the excel function (see about) says it can't see it. 28(Sittin' on) the Dock of the Bay - Otis Redding (1968) My end result will be to extract the artist from the list of 500 songs. If anyone has a better approach, I would love to hear it. Thanks, HPB 
|
|
#2
December 16th, 2005, 08:39 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
unrecognized character
With the data in A1 this will do it
=TRIM(LEFT(MID(A1,FIND("-",A1)+1,255),FIND("(",MID(A1,FIND("-",A1)+1,255))-1 )) -- Regards, Peo Sjoblom "harvdog" wrote in message ups.com... I am trying to SEARCH or FIND a text string in an excel file without any luck. The character is a hyphen (-) and the excel function (see about) says it can't see it. 28(Sittin' on) the Dock of the Bay - Otis Redding (1968) My end result will be to extract the artist from the list of 500 songs. If anyone has a better approach, I would love to hear it. Thanks, HPB
|
|
#3
December 16th, 2005, 11:04 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
unrecognized character
Try DataText to ColumnsDelimited byOther. Enter a hyphen and Finish.
Gord Dibben Excel MVP On 16 Dec 2005 12:29:29 -0800, "harvdog" wrote: I am trying to SEARCH or FIND a text string in an excel file without any luck. The character is a hyphen (-) and the excel function (see about) says it can't see it. 28(Sittin' on) the Dock of the Bay - Otis Redding (1968) My end result will be to extract the artist from the list of 500 songs. If anyone has a better approach, I would love to hear it. Thanks, HPB
|
|
#4
December 17th, 2005, 01:47 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
unrecognized character
If the data was imported from the web, there's a good chance that you might
have a "non-breaking" hyphen, same as the non-breaking spaces that one finds so often in web imported data. In the "Find What" box, Hold down Alt, and type 0173 Using the numbers from the num keypad, *Not* the numbers under the function keys. Let us know if that works. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "harvdog" wrote in message ups.com... I am trying to SEARCH or FIND a text string in an excel file without any luck. The character is a hyphen (-) and the excel function (see about) says it can't see it. 28(Sittin' on) the Dock of the Bay - Otis Redding (1968) My end result will be to extract the artist from the list of 500 songs. If anyone has a better approach, I would love to hear it. Thanks, HPB
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| What is the problem with my SELECT statement ? | Adrian Constantin | Running & Setting Up Queries | 4 | December 13th, 2005 05:08 PM |
| Use of Character styles | Sverre Medalen | General Discussion | 8 | August 25th, 2005 01:54 PM |
| Automatic Update with character styles | Martinphilip | General Discussion | 2 | May 3rd, 2005 04:42 PM |
| How do you end or "turn off" a character style while entering text | Larry Root | General Discussion | 3 | April 25th, 2005 03:29 PM |
| Special Ansi Character on report: Section Symbol | RNUSZ@OKDPS | Setting Up & Running Reports | 4 | March 29th, 2005 03:53 PM |
Linear Mode
