Split the words

Let say in 'A1' I input as "AARON WONG".
How to make it to 'B1' as "AARON" and 'B2' as "WONG"?

And

Let say the text in 'A1' as "BCBB123456-IP SEMINAR".
How to make it to 'B1' as "BCBB123456" then 'B2' as "-IP SEMINAR"?
0
KelvinLee (9)
10/10/2005 2:00:10 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
374 Views

Similar Articles

[PageSpeed] 36

Data->'Text to Columns'->Choose Delimited and select the appropriate delimiter


-- 
Regards,
Dave


"Kelvin Lee" wrote:

> Let say in 'A1' I input as "AARON WONG".
> How to make it to 'B1' as "AARON" and 'B2' as "WONG"?
> 
> And
> 
> Let say the text in 'A1' as "BCBB123456-IP SEMINAR".
> How to make it to 'B1' as "BCBB123456" then 'B2' as "-IP SEMINAR"?
0
10/10/2005 2:22:03 PM
Reply:

Similar Artilces:

Split tasks a splitting headache
Inherited another Project IMS. I am noticing right off that the previous scheduler has been starting tasks without their FS preds completing. Yeah, it does show up as a spit bar in the gantt chart. But, does anyone know a way to filter out just task that started before predecessor completion? I'm dealing with several thousand lines. Thanks. -- trailerpup ------------------------------------------------------------------------ trailerpup's Profile: http://forums.techarena.in/members/116596.htm View this thread: http://forums.techarena.in/microsoft-project/1290853.htm ...

Date form field in Word
I've created a form using the drop-down date field. However, after saving and restricting editing on the document, the form works when tabbing TO the date field but after selecting a date, the "form" will not tab to the next field, which happens to be a fill-in field: it will only tab to the next date field. HELP! If the date fields are Date Picker content controls, what you are seeing is to be expected. You cannot Tab from a content control to a field in Word. -- Stefan Blom Microsoft Word MVP "April" <April@discussions.microsoft.com> wrote...

How to randomly split a whole dataset into two sub-dataset?
Hi, At your possible convenience, might anyone please kindly answer my question? Thank you very much. How to "RANDOMLY" split the whole data set (n=2000) into two sub dataset (n=1000; n=1000) in SPSS or Excel? Thank you very much. Please take care Caroline zencaroline <zencaroline@gmail.com> writes: > How to "RANDOMLY" split the whole data set (n=2000) into two sub > dataset (n=1000; n=1000) in SPSS or Excel? Create a new variable whose value is randomly distributed. Sort the data on this variable. Take the first 1000 cases ...

Can't find my Front End Folder after database split
I just split my database base to allow for ease of use for multiple users. Ererything, it seemed, went smoothly until i try to find the fron-end folder. It is nowhere to be found. Should it be label ****_fe.mbd like the back end? Please help. Thaanks. It will be called that, unless you typed something else in the save as dialog. I thought it ended up in the same folder as the backend after splitting. Easiest way is to go back to the original and split it again, this time take note of where you save it before you press the button. Jeanette Cunningham "Joe" <Joe@discussi...

Word Count when saving large documents
On some large documents, but not all, there is a verrrry long delay when saving the document as it repeatedly recalculates the number of words in the document. Is there a way to turn off the Word Count function in such documents?? Thanks. -- Cyndie Browning Software Support Specialist GableGotwals Tulsa, OK Hi Cyndie, Getting the word count is almost instantaneous - and doesn't rely on the save process for an update. If you're working over a network, the *network* may be the cause of the poor performance. -- Cheers macropod [Microsoft MVP - Word] "...

Unwanted replicated split screen
I know I could re-install excell but before I do, is there anyone here who can help me disable a setting that I have no idea how it came about. I can only describe it as 2 identical execl grids on the same worksheet. Accompanying image will show you. Help. Thanks. +-------------------------------------------------------------------+ |Filename: excel_display_duplication.GIF | |Download: http://www.excelforum.com/attachment.php?postid=3855 | +-------------------------------------------------------------------+ -- BoyLeroy -----------------------------------...

Export a Word DOC document as PPT PowerPoint
In Word 2007 is there a way to save or export a DOC document as PPT PowerPoint? (or DOCX to PPTX) Thanks, SantistaS It works the other way -- in PowerPoint, you _import_ a Word document. (Which is supposed to be done in the form of an Outline, using the built-in styles Heading 1 etc., and then it turns them into slides based on the headings.) If you want pieces of text from a Word document to appear in text boxes in slides, just copy and paste. (You can even drag selected text from one to the other.) On Feb 18, 10:21=A0am, "SantistaS" <santis...@hotmail....

Display Data On Split Form
Not sure how to ask this but here goes. In AC 2007 I have a split form that I want to display a value that will show regardless of the row I select in the datasheet. This is the number of vacation days one will have through-out the year and of course it changes as vacations days get used up. Any help will be appreciated, James "JamesJ" <jjy@darwin_roadrunner.com> wrote in message news:6A4DFFD9-3302-4A10-B51A-153373D266FD@microsoft.com... > Not sure how to ask this but here goes. > In AC 2007 I have a split form that I want to display a value > that will show regardl...

Split data into new sheets
I have a (very) long list, sorted by account code. I would like to write a macro that splits the list into separate sheets in the workbook, with a separate sheet for each account code. Ideally, I would also like to rename each sheet to show which account code the sheet contains. I have no idea, though, where to start. Any ideas? Thanks in advance. Hi bernard How many different accounts are in the list (more or less than 250)??? below some code that I use to split files by account numbers where the user has to select a cell within the column that contains the account number... Hope thi...

Pasting fractions from Word; changing into dates
I am trying to paste a row of fractions in a Word table into an Excel worksheet. The column is formatted as Fraction. But every Paste and Paste Special I try puts these in and converts them to dates! Is there any way around having to type these in by hand? Ed You can make it work if you put a 0 in front of each fraction in your Word document and then copy and paste that into your fraction formatted cells, e.g. to copy and paste 1/2 3/4 you would enter them in Word as 0 1/2 0 3/4 A Jones "Ed" wrote: > I am trying to paste a row of fractions in a Word table into...

AutoOpen embedded Word Doc
I have an embedded word document on a worksheet - I was wondering if it was possible to have an automatic macro run in the word document when it is double clicked on the excel spreadsheet. I have tried having an AutoOpen macro in the word document but it doesn't seem to get activated... Help! TIA Stewart Walker MOS Excel Expert (you wouldn't know it though with the amount of questions I ask!!) ...

split column
I have a column of data in the following format column A John B. Smith What I want to do is split this column into three separate column so that it will appear as below Column B Column C Column D John B. Smith. Is there a formula that can help me do this. TIA Tlee, If all the names follow the same format (you don't say), you can use Data - Text to columns, using a space as the separator. Make sure that the columns to the right are empty before you start. -- Earl Kiosterud mvpearl omitthisword at verizon period net ---------------------------...

save split table in word
I am in word; after I split the window, I need to save but it won't let me. How do I save the split window in word? "Split window" is something that doesn't get saved when you close your document. On Feb 3, 11:49=A0am, chellehicks <chellehi...@discussions.microsoft.com> wrote: > I am in word; after I split the window, I need to save but it won't let m= e. =A0 > How do I save the split window in word? ...

Reverse Split
Money International Version 2003 trying to do a 0.25 for 1 split. Money wants integers in the split field, so I tried to do a 1 for 4 "split". Money gave a completely unrelated answer. I then did a 50 for 200 "split" (I have 200 shares being reduced to 50) - again it gave a number completely unrelated. I tried various permutations and each time, the division or multiplication numbers were total nonsense. Any help? In microsoft.public.money, ZootRot wrote: >Money International Version 2003 > >trying to do a 0.25 for 1 split. Money wants integers in ...

How do I remove split a split window?
I selected "View" "split" and now have a split window. How do I remove the split? "Norm" <Norm@discussions.microsoft.com> wrote in message news:33CA1631-20A1-457C-A797-F9ECE0180ED8@microsoft.com... >I selected "View" "split" and now have a split window. How do I remove the > split? Same way as you split it.... Or double click the "line". -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Gordon" wrote: > "Norm" <Norm@discussions.microsoft.com> wrote in message > news...

Word wrap #3
I'm using Publisher 2002, and I need to know how to wrap text around a photo or clipart. Jeff Bring the photo to the front. Select the photo, Arrange menu, Order. -- Mary Sauer http://msauer.mvps.org/ "Jeff Stanton" <jstanton@hughes.net> wrote in message news:Grg_k.43167$zQ3.17812@newsfe12.iad... > I'm using Publisher 2002, and I need to know how to wrap text around a photo > or clipart. > Jeff > > ...

Paste into "Advanced Find" "search for the words:" field????
Am I doing something wrong, or did microsoft really disable the ability to paste into the "search for the words:" field? You can paste into the email address fields, but that is it. I'm trying to search emails for a specific numeric string, and I don't want to have to type a 30 character number from an email when I could easily copy and paste it. Am I doing something wrong or are they really that stupid??? Thanks! Mick Does CTRL V work for you "Mick" <MickBurkellc@gmail.com> wrote in message news:1121234980.931014.46200@z14g2000cwz.googlegroups.com... >...

table relationships and split dbs
I have asked before and now can't find the post (also have a few extra questions than before) regarding table relationships and split databases. 1. Where should relationships be created? Front-end or Back-End? 2. Do they need to be in both? 3. If you have relationships in the Back-end and then create some in the Front-End, which take precedance? 4. In the case that they are in the back-end, they will still get 'followed' in the front-end? I'm sure you get the jist of my question, any explanation to the proper method of implementing and enlightenments on relati...

Split shares don't show up in report
I recently installed Money 2005 Standard and have entered details about stocks and later recorded that they were split. For eg. intially I had entered purchase of 1 share for $10 and then recorded the split at 1:1. The account register still shows number of shares as 1 and price as $10s. The account summary also shows that I have just 1 share and not 2. Any help? Same answer to same question. "TomDick" <TomDick@discussions.microsoft.com> wrote in message news:F2FC2358-A296-4A97-AB78-C02665A0BC37@microsoft.com... >I recently installed Money 2005 Standard and have ent...

splitting a database, where question
I have built a small but useful database on my own work pc, and now need to split it for other users. So I wondered if it was best to split it on my own machine then place the BE on the server, then copy the front end to local machines. OR, place the whole unsplit database on the server, then split it, and copy the front end from the server to local machines. Thanks On Sat, 21 Nov 2009 16:25:38 +0000, Bob H <bob@despammer.com> wrote: I would first make a backup. Then copy my db to the server. Then on my workstation's version delete all the tables. Then use the Imp...

word #6
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: intel how do i turn off the auto correct feature, specifically the feature that changes the font of new/edited text I'm afraid there is no AutoCorrect feature that does what you describe. Rather than replying to an expired 6 week old thread on a totally unrelated matter how about posting a New message? Please include exact version information for OS X & Office along with a more complete description of exactly what is happening as opposed to what you expect. Is it a specific document, all documents, new documents only? ...

How do I reformat existing line lengths in Word 2007?
Let's say I have a Word 2007 line length of 7 inches in my document. When I cut/paste some email plain text into the document, it arrives with a line length of 4 inches and odd line breaks. How do I "reformat" or "retab" or "flow" the pasted text en masse so that it "knows" that it should fill each line to 7 inches before breaking to the next? Doing it manually takes forever. Thanks! See http://word.mvps.org/FAQs/Formatting/CleanWebText.htm -- <>>< ><<> ><<> <>>< ><<...

Can't move or delete Word file in Win Explorer: file in use
I have Win XP Pro SP3. When using Win Explorer, I sometimes cannot move or delete a file. I get the message that the file is being used by another person or program. Here's how to reproduce the problem: - Open a file in Word. - Make a change. Save and close the file. - Try to move or delete the file in Win Explorer. Sometimes I can release the file simply by closing Word. At other times, I need to reboot. Any advice? You will not be able to move or delete a Word document until its lock file has been released. All lock files should be released when Word is closed (o...

Problems printing a word document with linked excel tables.
I am having trouble printing a word document that has linked excel tables in it. When I print the document, some of the linked excel tables get skewed and distorted. However, they look normal on screen. What causes this? How can I fix it? -- jc ...

SPLITTING
Hi there..... I've finally gotten the database together and I attempted to have it shared between two users....however I was reading about splitting the database....can anyone give me some concrete instructions about how to make this work effectively. I have three people who need to access the database that's all. However I know it's possible that two people will be in it at the same time, entering information? Any suggestions? Thanks Ransom Check out the wizard in Tools>>Database utilities>>Database Splitter (Access 2003) Very straightforward and low risk. ...