Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Drew Drew is offline
external usenet poster
 
Posts: 26
Default Formatting a merge field that contains both text and numbers

I have a field that merges both text and a number to my document. I'd like
to supress the number and keep the text.

I'd like to go from this:
Text-123-45-6789
to this:
Text

Any suggestions? Thanks


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Formatting a merge field that contains both text and numbers

Hi Drew,

Mailmerge can't do that. You'll need to separate the data at its source and merge just the part you need.

--
Cheers
macropod
[Microsoft MVP - Word]


"Drew" wrote in message ...
I have a field that merges both text and a number to my document. I'd like
to supress the number and keep the text.

I'd like to go from this:
Text-123-45-6789
to this:
Text

Any suggestions? Thanks


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Formatting a merge field that contains both text and numbers

If the number is always of the format -###-##-####, after executing the
merge to a new document, you could to a Wildcard Replace that replaces

-[0-9]{3}-[0-9]{2}-[0-9]{4}

with nothing.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Drew" wrote in message
...
I have a field that merges both text and a number to my document. I'd like
to supress the number and keep the text.

I'd like to go from this:
Text-123-45-6789
to this:
Text

Any suggestions? Thanks



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Formatting a merge field that contains both text and numbers

Hi Doug,

If the document has that kind of info elsewhere (eg because the full string is required in a particular location), one couldn't use
the 'Replace All' option - every instance would have to be stepped through. Conversely, if there is always a particular string
before/after the expression from which the numbers need to be deleted that doesn't appear elsewhere in the document, the
Find/Replace parameters could be modified to suit the 'Replace All' option.

--
Cheers
macropod
[Microsoft MVP - Word]


"Doug Robbins - Word MVP" wrote in message ...
If the number is always of the format -###-##-####, after executing the merge to a new document, you could to a Wildcard Replace
that replaces

-[0-9]{3}-[0-9]{2}-[0-9]{4}

with nothing.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Drew" wrote in message ...
I have a field that merges both text and a number to my document. I'd like
to supress the number and keep the text.

I'd like to go from this:
Text-123-45-6789
to this:
Text

Any suggestions? Thanks




  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Formatting a merge field that contains both text and numbers

What is the data source?

Are you in a position to use VBA code?

Peter Jamieson

http://tips.pjmsn.me.uk

On 02/02/2010 14:29, Drew wrote:
I have a field that merges both text and a number to my document. I'd like
to supress the number and keep the text.

I'd like to go from this:
Text-123-45-6789
to this:
Text

Any suggestions? Thanks


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge formatting numbers Alex Hammerstein Mailmerge 2 February 3rd 09 12:27 PM
Merge Excel to Word, preserving "text" field formatting(italics) wendy christensen Mailmerge 1 January 14th 09 07:45 PM
Formatting numbers in mail merge [email protected] Microsoft Word Help 1 December 3rd 07 04:13 PM
MERGE NUMBERS WITH COMA FORMATTING hotty Mailmerge 1 December 30th 05 02:41 PM
Merge Field Formatting Matty_b Mailmerge 1 May 10th 05 03:03 PM


All times are GMT +1. The time now is 11:02 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"