| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export text
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export text
In A3: =MID($A$1,ROW(A1)*3-2,2)
copy down "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export text
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export text
Depending whether your source cells pattern is consistant. If it holds as
AA/DZ/EA XX/XX/XX then If above cell is in A1; In B1 enter: =Left(A1,2) In C1 enter: =Mid(A1,4,2) In D1 enter: = Right(A1,2) Should work for you,,, Jim May "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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export text
Thank you all
"Jim May" wrote: Depending whether your source cells pattern is consistant. If it holds as AA/DZ/EA XX/XX/XX then If above cell is in A1; In B1 enter: =Left(A1,2) In C1 enter: =Mid(A1,4,2) In D1 enter: = Right(A1,2) Should work for you,,, Jim May "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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export text
Theethless,
Next to your name I see a bronze stat, but on another post from today I see a silver star. ? "Teethless mama" wrote: In A3: =MID($A$1,ROW(A1)*3-2,2) copy down "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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export text
Thank you all
"Teethless mama" wrote: In A3: =MID($A$1,ROW(A1)*3-2,2) copy down "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. |
|
#8
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. |
| Reply |
| 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) | |||
Linear Mode
