LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Split Alpha Field

I have a persons name and initials in a single Excel [XP] cell such as [Adams
J K] and [Adams L]. Is it possible to split the initials from the surname
into separate cells. This is to enable them to be in two columns in Word
before transferring to Publisher. I have over 1000 to do!
Thanks, Dick W.
 
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
Prevent alpha character from being entered into a numeric field Brazil Excel Worksheet Functions 3 July 21st 08 07:12 PM
Split field dk New Users to Excel 14 January 10th 08 02:22 AM
HOW DO YOU COUNT ALPHA CHARACTERS IN AN ALPHANUMERIC FIELD PVSPRO Excel Discussion (Misc queries) 4 August 31st 07 12:04 AM
Split the numbers in a alpha numeric case Jp Excel Discussion (Misc queries) 5 April 7th 06 09:29 PM
Merge an alpha field and a numeric field grams Excel Discussion (Misc queries) 3 August 29th 05 11:33 PM


All times are GMT +1. The time now is 10:55 PM.

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

About Us

"It's about Microsoft Excel"