Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to split up text
How to change
LSD/1/1 REMAD/1/2 NSFE/1/1 CLKSAD/2/1 into LSD 1 1 REMAD 1 2 NSFE 1 1 CLKSAD 2 1 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to split up text
On Jul 10, 8:10 pm, "Hilton" wrote:
How to change LSD/1/1 REMAD/1/2 NSFE/1/1 CLKSAD/2/1 into LSD 1 1 REMAD 1 2 NSFE 1 1 CLKSAD 2 1 Thanks How to change LSD/1/1 REMAD/1/2 NSFE/1/1 CLKSAD/2/1 Use Convert Text to Columns - Either Ex 03 Tools/Text to Columns or Ex 07 Data/Text to Columns Select the column with the data in it. Select delimited and click Other and put / in the box provided Click ok and presto it will separate your data into separate columns. Cheers ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to split up text
Highlight your cells and then select from the menu Data - Text to Columns and
follow the steps through the wizard "Hilton" wrote: How to change LSD/1/1 REMAD/1/2 NSFE/1/1 CLKSAD/2/1 into LSD 1 1 REMAD 1 2 NSFE 1 1 CLKSAD 2 1 Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to split up text
Select your column then
Data|Text To Columns Select 'Delimited' Next Put a / in the other box Finish Mike "Hilton" wrote: How to change LSD/1/1 REMAD/1/2 NSFE/1/1 CLKSAD/2/1 into LSD 1 1 REMAD 1 2 NSFE 1 1 CLKSAD 2 1 Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to split up text
DataText to columns, set / as separator
Regards, Stefi €˛Hilton€¯ ezt Ć*rta: How to change LSD/1/1 REMAD/1/2 NSFE/1/1 CLKSAD/2/1 into LSD 1 1 REMAD 1 2 NSFE 1 1 CLKSAD 2 1 Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to split up text
On Thu, 10 Jul 2008 12:10:21 +0200, "Hilton" wrote:
How to change LSD/1/1 REMAD/1/2 NSFE/1/1 CLKSAD/2/1 into LSD 1 1 REMAD 1 2 NSFE 1 1 CLKSAD 2 1 Thanks If what you mean is to split your strings into columns, then: Use the Data/Text to Columns wizard (from the Data menu) and select Delimited; then "/" as the delimiter. If what you mean is to replace the "/" with multiple spaces, then use a formula similar to: =substitute(A1,"/"," ") --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split a text | Excel Worksheet Functions | |||
Split text without using data-text to columns | Excel Discussion (Misc queries) | |||
Split Text | Excel Discussion (Misc queries) | |||
Split text and number | Excel Discussion (Misc queries) | |||
text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) |