Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2019, 04:43 PM
jeffreybrown jeffreybrown is offline Subscript number proceeded by an "X" Windows Vista Subscript number proceeded by an "X" Office 2007
Expert
Subscript number proceeded by an "X"
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default Subscript number proceeded by an "X"

If have many instances of X followed by a number, but I only want to subscript the number if it's proceeded by a single X.



X1
X2
X3
X4
X5
X6
12
23
12
45

A wildcard Find/Replace:
Find = [0-9]{1,}
Replace = ^&

This subscripts everything, but not sure how to isolate the number.
Reply With Quote
  #2  
Old 01-24-2019, 05:36 PM
Guessed's Avatar
Guessed Guessed is offline Subscript number proceeded by an "X" Windows 10 Subscript number proceeded by an "X" Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,984
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Don't bother trying to isolate the number. Just subscript the lot and then do a second search and replace to make any subscript X into normal size.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 01-24-2019, 05:38 PM
jeffreybrown jeffreybrown is offline Subscript number proceeded by an "X" Windows Vista Subscript number proceeded by an "X" Office 2007
Expert
Subscript number proceeded by an "X"
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Thanks Andrew, but I don't want a number that is all by itself to be subscript.

So, in post #1, those last four numbers should not be subscript.
Reply With Quote
  #4  
Old 01-24-2019, 09:16 PM
macropod's Avatar
macropod macropod is offline Subscript number proceeded by an "X" Windows 7 64bit Subscript number proceeded by an "X" Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As Andrew said:
Quote:
Originally Posted by Guessed View Post
Just subscript the lot and then do a second search and replace to make any subscript X into normal size.
That means:
A wildcard Find/Replace:
Find = X[0-9]{1,}
Replace = ^&
subscripting the replacement
followed by:
Find = X
with the subscript attribute
Replace = ^&
removing the subscript.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-25-2019, 05:05 AM
jeffreybrown jeffreybrown is offline Subscript number proceeded by an "X" Windows Vista Subscript number proceeded by an "X" Office 2007
Expert
Subscript number proceeded by an "X"
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Ok thanks. I got it now. I had tried that, X[0-9]{1,}, but it wasn't working.

Wasn't working (my fault) because the number after the X is actually a SEQ field.

I will now have to switch the strategy to subscripting the SEQ field code when it is displayed.

All sorted. Thank you Andrew and Paul.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet with "CR" & "DB" in amount & number columns. bfisher Excel 4 09-28-2015 07:03 AM
Subscript number proceeded by an "X" Mailing: how to make the "page number" in Word is the same as "row number" in excel w Jamal NUMAN Word 1 09-03-2011 11:37 AM
Subscript number proceeded by an "X" How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
in WORD, how do i type a 9-digit phone number "xxxxxxxxx" and have it automatically.. jay8962 Word 0 04-08-2010 11:08 AM
Subscript number proceeded by an "X" Mysterious "Subscript out of range" error rnstewart Excel 4 12-29-2005 01:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:43 PM.


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