| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with test to columns feature identifying odd delimiting character
I have exported some stuff from an outlook inbox into excel for analysis.
The boby of the emails I have exported contain data which I need, each piece of data is on a seperate row in the email boby. "CDControls.iAD AnaBACK PRSR MBAR HIGH WARNING !! Reg No: TA656 Serial No: 666069 BATT: 26.9 volts GSM Sig: 20 db MEM:5481/86400 " When I export it it comes in to excel all in one cell with a character seperating each row that I cant reproduce. Its 2 very bold letter "l"'s which seems to the the character that forces the new row i the email. How can I identify the character to properly seperate each row above into seperate columns in the spreadsheet? All help appreciated Thanks Mark -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201004/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test left character is a number? | Excel Discussion (Misc queries) | |||
| Need help identifying a feature - driving me crazy | New Users to Excel | |||
| Is there a character count feature in Excel? | Excel Discussion (Misc queries) | |||
| Excel list feature should search with more than first character | Excel Worksheet Functions | |||
| Pasting from clipboard-how to control text-to-columns delimiting | Excel Discussion (Misc queries) | |||
Threaded Mode
