Reply
OpenOffice Calc & Spreadsheets Help
Old 09-03-2005, 10:38 PM OpenOffice Calc & Spreadsheets Help
Brian07002's Avatar
Super Spam Talker

Posts: 869
Name: ...
Location: ...
Hi All,

Can someone here assist me in OpenOffice Calc? (NOT MS-OFFICE)

My question:

I'm trying to search & replace some text. But, it needs to be quite specific. This is what I need to be able to do:

Actual Example: Search for 'X' (capital X) and replace with x (lowercase x) but it can only replace the 'X' with a 'x' if and ONLY if there is a number preceding it and following it...So it would be 10 x 5 (and NOT 10 X 5). But it must NOT change the X if it were part of a word. Meaning 'Xtremely Cool Product'

Thank you.
-Brian
Brian07002 is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 09-04-2005, 05:52 AM
chrishirst's Avatar
Super Moderator

Posts: 16,477
Location: Blackpool. UK
does OpenOffice support regular expression find and replace ? That would be the only way
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System | Bits & Bobs
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Reply     « Reply to OpenOffice Calc & Spreadsheets Help
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.12309 seconds with 12 queries