| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export text
Thank you all
"Tevuna" wrote: Assuming texting is in A1 For AA: =LEFT(A1,FIND("/",A1)-1) For DZ: =MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1) For EA: =MID(A1,FIND("/",A1,FIND("/",A1)+1)+1,LEN(A1)-FIND("/",A1,FIND("/",A1)+1)) "lindsayhyle" wrote: I have a list of text like in a cell like this: AA/DZ/EA and I want to pull it out of one cell and put in into different cells like this: AA DZ EA Is there a way to do that other than typing it individually (for longer lines of text)? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I export text from excel autoshapes to a text file? | Excel Discussion (Misc queries) | |||
| Need to export to text results not formula | Excel Discussion (Misc queries) | |||
| How to export text from Excel to Word | New Users to Excel | |||
| Can't export actual text - Get #### instead | Excel Discussion (Misc queries) | |||
| Export (or save as) .csv with text delimiters | Excel Discussion (Misc queries) | |||
Threaded Mode
