Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-20-2011, 12:36 PM
jkallstate jkallstate is offline I just want to add some delimiters :) Windows Vista I just want to add some delimiters :) Office 2007
Novice
I just want to add some delimiters :)
 
Join Date: Jan 2011
Posts: 2
jkallstate is on a distinguished road
Default I just want to add some delimiters :)

I am trying to convert a phonebook into a contact sheet all my data is in the standard phonebook form.

Example:

Jones Al 123 Somewhere State 555-555-0023
Mike 243 Somewhere State 555-233-5434
Steve 243 Somewhere State 555-233-5434
Zach 243 Somewhere State 555-233-5434

Smith A 243 Somewhere State 555-233-5434


Bill 243 Somewhere State 555-233-5434
Dave 243 Somewhere State 555-233-5434
Ed 243 Somewhere State 555-233-5434
Frank 243 Somewhere State 555-233-5434

What I ideally want is

Jones, Al, 123 Somewhere State 555-555-0023
Jones, Mike, 243 Somewhere, State, 555-233-5434
Jones, Steve, 243 Somewhere, State, 555-233-5434
Jones, Zach, 243 Somewhere, State, 555-233-5434

Smith, A, 243 Somewhere, State, 555-233-5434
Smith, Bill, 243 Somewhere, State, 555-233-5434
Smith, Dave, 243 Somewhere, State, 555-233-5434
Smith, Ed, 243 Somewhere, State, 555-233-5434
Smith, Frank, 243 Somewhere, State, 555-233-5434

This is where I am at using find and replace functions

Jones Al 123 Somewhere, State, 555-555-0023
Mike 243 Somewhere, State, 555-233-5434
Steve 243 Somewhere, State, 555-233-5434
Zach 243 Somewhere, State, 555-233-5434

Smith A 243 Somewhere, State, 555-233-5434
Bill 243 Somewhere State, 555-233-5434
Dave 243 Somewhere, State, 555-233-5434
Ed 243 Somewhere, State, 555-233-5434
Frank 243 Somewhere, State, 555-233-5434

So I just need to get the last names to copy to the corresponding lines and place commas in there (after the last and first name).

There is a difference in the last name versus the first names that would allow this I believe. The Last name is font size 6 and the first name is 5.5. And both the first and last name are bold while the remaining text is not bold. Any help would be appreciated. Thanks!
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft