Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 202
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,646
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split a text Manos Excel Worksheet Functions 7 October 17th 07 05:51 PM
Split text without using data-text to columns Jambruins Excel Discussion (Misc queries) 7 January 21st 06 03:16 PM
Split Text Gabe Excel Discussion (Misc queries) 6 January 4th 06 10:52 PM
Split text and number Jambruins Excel Discussion (Misc queries) 5 October 5th 05 09:56 PM
text cells end page how split to next. Text lost! Elaine Excel Discussion (Misc queries) 1 August 28th 05 05:48 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"