Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How separate a Long text by first space?
I have texts like this in a field example Column A a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution I want them separated by first space that exist from left to right, example: Column A Column B a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution Thanks in advanced. -- Lorenzo DÃ*az Cad Technician |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How separate a Long text by first space?
I would do it with 2 formulas...
=LEFT(E1, FIND(" ", E1)-1) and =MID(E1, FIND(" ", E1)+1, 256) That will give you the seperate values. You can then copy and paste them as values if you wish... -- HTH... Jim Thomlinson "ldiaz" wrote: I have texts like this in a field example Column A a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution I want them separated by first space that exist from left to right, example: Column A Column B a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution Thanks in advanced. -- Lorenzo DÃ*az Cad Technician |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How separate a Long text by first space?
great,
It works perfectly.. Thanks -- Lorenzo DÃ*az Cad Technician "Jim Thomlinson" wrote: I would do it with 2 formulas... =LEFT(E1, FIND(" ", E1)-1) and =MID(E1, FIND(" ", E1)+1, 256) That will give you the seperate values. You can then copy and paste them as values if you wish... -- HTH... Jim Thomlinson "ldiaz" wrote: I have texts like this in a field example Column A a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution I want them separated by first space that exist from left to right, example: Column A Column B a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution Thanks in advanced. -- Lorenzo DÃ*az Cad Technician |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How separate a Long text by first space?
Select the entire list in column A. Then go to the Data menu and choose Text
To Columns. There, select the "Delimited" option, and click Next. Now, check the "Space" item in the list of delimiters. Finally click Finish. This will split the text in column A into as many columns as required, based on the number of spaces in the source text. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "ldiaz" wrote in message ... I have texts like this in a field example Column A a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution I want them separated by first space that exist from left to right, example: Column A Column B a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution Thanks in advanced. -- Lorenzo DÃ*az Cad Technician |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How separate a Long text by first space?
Copy Column A to Column B so you have the same original list in both
columns. Select Column A and click Edit/Replace on Excel's menu bar. Put the following in the "Find what" field... " *" but leave out the quote marks so only a space followed by an asterisk appear in the field... and leave the "Replace with" field empty... then click the "Replace All" button. Now select Column B and put the following in the "Find what" field (still leave the "Replace with" field empty)... "*-* " again, leave out the quote marks so only asterisk, dash, asterisk space appear in the field... then click the "Replace All" button. Your text should be distributed in your columns as you wanted. -- Rick (MVP - Excel) "ldiaz" wrote in message ... I have texts like this in a field example Column A a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution I want them separated by first space that exist from left to right, example: Column A Column B a-x00-sss-rtds Right tool, die short a-x00-sss-maxss Max SS a-x00-sss-longdie Long die used a-x00-sss-red Red Solution Thanks in advanced. -- Lorenzo DÃ*az Cad Technician |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Space in text | Excel Discussion (Misc queries) | |||
How do I print two separate cells in a certain space on a form | Excel Discussion (Misc queries) | |||
How do I separate text without a space? | Excel Discussion (Misc queries) | |||
Long Date - Long Date = text is days | Excel Discussion (Misc queries) | |||
I held the space bar down for too long in EXCEL. | Excel Discussion (Misc queries) |