|
#1
|
|||
|
|||
Cell content splits
I have two questions: 1. I have number of names in a column. Names are written as First Name space and Surname. (eg. George Washington) How do I split into two columns?. (First name into one cell and Surname into another cell) 2. How do I convert lower case words into uppercase. Thanks. - Mahen |
#2
|
||||
|
||||
Hi Mahen,
If they're only a single given & surname per cell, using Excel's Text-to-Columns tool will do the job. See under Data|Text-to-Columns. Use the space as the delimiter. For the case conversion, you can use a formula like: =UPPER(A1) where the string to be converted is in A1.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Paul,
Excellent, both worked. Thank you so much. - Mahen |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? | Learner7 | Excel | 1 | 04-25-2011 04:39 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Package for CD with links to Windows media player content and Flash Shockwave content | hectorh | PowerPoint | 4 | 10-15-2009 12:22 PM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |