Separate cell text FirstnameLastname into two columns
How can I separate a column of cells containing a single text string in each[these are names formated as a string with no delimiter as in "FirstLast" with the first letter of first and last name capitalized and the rest lower case...] into two columns of text called Firstname and Lastname? Thanks!:) -- drewannie ------------------------------------------------------------------------ drewannie's Profile: http://www.excelforum.com/member.php...o&userid=36079 View this thread: http://www.excelforum.com/showthread...hreadid=558632 |
All times are GMT +1. The time now is 10:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com