Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jobby55
 
Posts: n/a
Default how do I create a formula to seperate name into two cells (last, .

Is there a formula to seperate a name in one cell (last, first) and make them
into 2 cells?
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Jobby,

You could use tht Text To Columns feature.

With the name cells selected, try:

Data | Text To Columns | Delimited | Next | Select appropriate
delimiter |
Next | Next | Finish

---
Regards,
Norman



"jobby55" wrote in message
...
Is there a formula to seperate a name in one cell (last, first) and make
them
into 2 cells?



  #3   Report Post  
Ragdyer
 
Posts: n/a
Default

The most direct way is to use "Text To Columns", since this procedure
produces the actual data in adjoining columns, with *no* underlying
formulas, which may have to be eliminated, going forward.

Select the column of names, then:
<Data <TextToColumns, and make sure that "Delimited" is checked.
Then, <Next,
Now, check whatever your delimiter is, "Space or Comma", then,
<Finish.

You should now have your names separated into 2 or 3 columns, where you can
do whatever.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jobby55" wrote in message
...
Is there a formula to seperate a name in one cell (last, first) and make

them
into 2 cells?


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
how can i create a formula or format the cells so the answer is a. jenniss Excel Discussion (Misc queries) 5 January 6th 05 05:50 PM
Excel 2003 - cells in formula? Tom Walker Excel Discussion (Misc queries) 1 December 24th 04 02:14 AM
Hiding Formula in cells thrava Excel Discussion (Misc queries) 2 December 23rd 04 01:42 AM
create a chart with a formula anon Charts and Charting in Excel 1 December 15th 04 09:55 PM
Using color to ignore cells in a formula????? Mike A. Excel Discussion (Misc queries) 2 December 8th 04 06:35 PM


All times are GMT +1. The time now is 11:43 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"