Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Text issue

  Asked By: Bonni    Date: Aug 27    Category: MS Office    Views: 653
  

I am trying to create a database from an ini file in pcdj. I can import
it into Excel no problem but to parse the text I am using text
formulas. I am fairly proficient with text formulas but the section of
text I want to isolate is between these characters: | and ||. I cannot
(even cutting and pasting them) get Excel to recognise them. Sometimes
it thinks they are letter Ls, sometimes seemingly random characters.

An example line from the textfile is this:

Track16=000.00;Shania Twain;Honey I'm Home;;;Id=0-0;;Pop;;|Honey I'm
Home.mp3||C:\Documents and Settings\Legal User\My Documents\My
Music\Sue's MP3\|||F8371CEA

I am trying to extract this:

Honey I'm Home.mp3

My questionable musical tastes aside(!), any ideas, anyone?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Vilhelm Fischer     Answered On: Aug 27

I have the following text  in a Cell:
4.398.783

I want to convert this text to number:
4398783

Is there any Excel function o VBA code to do it?

 
Answer #2    Answered By: Kyle Fox     Answered On: Aug 27

I have the following text  in a Cell:
4.398.783

I want to convert this text to number:
4398783

Is there any Excel function o VBA code to do it?

 
Didn't find what you were looking for? Find more on Text issue Or get search suggestion and latest updates.




Tagged: