Macro to remove text
Could one of the resident macro experts kindly help me to do this
please. There is text in column D of a worksheet. I want to remove
anything that is in brackets, including the brackets.
A B C D
-- -- --------------- -------------------------------------------
1 P Andrews Sisters Boogie Woogie (1941 version)
2 Q Artie Shaw (1941) Concerto For Clarinet (Parts 1 & 2)
3 R Artie Shaw Dancing In The Dark
4 S Artie Shaw Frenesi
1 P Andrews Sisters Boogie Woogie
2 Q Artie Shaw Concerto For Clarinet
3 R Artie Shaw ...Unbound Text field in continous form
I have tried looking in all the groups but cannot find an answer to
this - i'm either blind or it's not obvious.
I have a continous form which lists assets, each asset has multiple
owners. I would like to display the owners details such as division
and tel number in a text box on the same line as the asset. Currently
if i add the owner it then double up the assets in the form.
I hope you can help as it is driving me mad.
Since an Asset can have multiple owners, the owners can not be included in the Asset
subform. Assets should be in one table , and owner...Can't send a link from IE 6
Installed Outlook 2003 recently, and now I cannot send a link to a page from
IE6. I ran Tweakol2003 so I can receive links, etc.
Something really simple I'll bet, but I have looked thru the help files and
have not hit on it yet.
Thanks for any guidance ...
Patch <firstname.lastname@example.org> wrote:
> Installed Outlook 2003 recently, and now I cannot send a link to a
> page from IE6. I ran Tweakol2003 so I can receive links, etc.
How do you know you can't send it?
Usually when the you try and send a link, a Outlook form comes up over the
IE screen jus...sending attachments in rich text format
This is a multi-part message in MIME format.
Can anybody tell me how I send an attachment with an e-mail from within
Microsoft Office 2007 in rich text format please
R0lGODlhEwAfAPcAAP8ICP8PDv8VFf8dHP8kI/...Outlook 2002 on Exchange 5.5 -- RTF to Plain Text issues
The owner of our company wants ALL email sent to him in Rich Text
Format so he can use an abbreviation program he has that works with MS
Word when replying. I created a document telling people how to change
their settings for Outlook to ensure all messages are sent in Rich
Text. My problem is that since he travels so much he wants to be a
POP user on our server. If I send him a message from my PC directly
connected to the Exchange server he receives it in RTF. If the
President of the company (who is also a POP user) sends him a msg in
RTF he receives it in Plain Text. He wants me to expla...Attachments convert to text format
When I send a message with an attachment in Outlook XP some receivers claim
that all they receive is a text mail.
My default mail format is plain text. If I change it to HTML I fear some
recivers would not see the content at all.
How can I solve it ?
Note: I change the format of a particular mail if it contains an
attachment, but sometimes I miss to do that.
> When I send a message with an attachment in Outlook XP some receivers claim
> that all they receive is a text mail.
> My default mail format is plain text. If I change it to HTML I fear some
> recivers ...copying text on sheet 1 to corresponding cells on sheets 2 to 5
I want the text entered in A8 on sheet 1(named Productivity) to automatically
transfer to A8 on sheets 2 thru 5. I used the simple formula
=Productivity!a8 in the corresponding cells but when there is no data in
Productivity A8 I get a 0 in the corresponding cells. I would like the
corresponding cells to remain blank if there is not text in Productivity A8.
I am really new to excel, like only used it two weeks! Is there a simple fix
newbie at large!
A formula will always return 0 if it's refering to an empty cell. This
formula will let the cell look empty if no...text in cell shows up as ####
Operating System: Mac OS X 10.5 (Leopard)
Text in cells in a coumn shows up as ####, apparently because there is a large amount of text. When I mouse over, the text shows. It also shows up in the formula bar. How can I copy and or print the text in these cell? <br><br>When I try to save these cells as text and transfer to Word, they continue to print as ###.
text in cell shows up as #### <br>
I am totally new to this whole environment! A new iMAC and this software. <br>
However, in trying to learn how to use EXCEL, I found that...Hide text box
I am trying to hide a text box on a subform if a check box is = to false. I
am close in doing so, but not there yet. This is what I have
In the AfterUpdate property of the check box I have the following:
Private Sub RevisedGrant_AfterUpdate()
If Me![RevisedGrant] = True Then
If MsgBox("Are you sure you want to revise this grant?", vbYesNo) =
Me![RevisedGrant] = False
MsgBox "Grant will NOT be revised", vbOKOnly
Forms![DataEntryFrm]![ItemSubFrm]![Total$ofItemsRequestedSubfrm].Form![Revised Total Approved].Visibl...Figures locked in text format
I imported data from a web page and used the feature that allows me to post
the info to Excel with the destination formatting of the file I am posting it
to. However, when I try to manipulate the data, as I have done in the past
with other data, it will not let me reformat the text to number- no matter
what I do to it. I've tried everything! I want to be able to sum the column,
Give us an example of the data you are working with. And what have you tried
to "do to it"?
"Marcia" <Marcia@discussions.microsoft.com> wrote in ...can not receive emails with web links attached
Could someone tell me how to change controls to allow for
emails with website links attached to come through? I
can not receive emails with website links attached.
...Deleting Linked Source(s)
In Excel 2000, how do you delete a link Source(s)? I know
you can 'clear contents' in each destination cell to
achieve this, but is there a simpler way. Can be difficult
to determine which cells are in fact destination cells.
This may help you
>In Excel 2000, how do you delete a link Source(s)? I
>you can 'clear contents' in each destination cell to
>achieve this, but is there a simpler way. Can be
>to determine which cells are in fac...Link to external workbook
I want to change a formula linking to a cell in a workbook on another server
so that the server name is used rather than the drive mapping.
I have tried the following but I keep getting 'File Not Found':
'\\Server Name:\Drive Name\......
(instead of 'G:\.....
\\Server Name:\Drive Name\
Doesn't look like a valid format...
I think I'd use windows start button|run
and point and click down the paths to find the correct workbook.
If you turn "View|toolbars|address bar", then you may be able to see the path...Link for downloading online statements not visible Mon 2k3
On my financial institution's(TCF Bank) website, there
are instructions for downloading online statements that
refer to a link on the BALANCES page for MS Money. The
problem is that the link apparently doesn't show up in my
version (MS Money 2003 ver. 11). I spent some time on
the phone with TCF's customer support and frustratingly
tried to argue that there was no link to click on to
download my statement both in Money and in Internet
Explorer. Therefore I thought it was a problem with
their website. However, they say that they recently
updated their system to automat...List number of permutations for text nums
I've got 4 digit text nums in A1 down
In B1 down, I would like to list the corresponding number of permutations,
Game for any formula, udf or other vba solution
Thanks for insights
Dim I As Integer, J As Integer, Rng As Integer
Rng =3D Cells(Rows.Count, "B").End(xlUp).Row
J =3D 1
Do Until ActiveCell.Value =3D ""
For I =3D 1 To Rng
Cells(J, "D").Value =3D "'" & ActiveCell & Cells(I, &qu...Transposing Links
I'm trying to link one file to another and copy the information. One file lists the info in a column, the other in a row, and I want to be able to drag (copy and paste) the linked info across the row (from the column) in my new file. Is this possible
Thanks for your help.
I don't think you can do a drag. What you can do is copy
the column and do a paste special->transpose.
>I'm trying to link one file to another and copy the
information. One file lists the info in a column, the
other in a row, and I want to be able to drag (copy and
p...Tracing Links #2
That tells me what file I am linking to, but what I want to identify i
which cell in my current worksheet is linked to these externa
worksheets, as I cannot find a reference to the external documen
anywhere in my current workbook.
The reason I ask is that I am trying to avoid the "Do you wish t
update links" message when opening my file.
Stephen Pain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1526
View this thread: http://www.excelforum.co...Simple question about text within a cell
I can't seem to find the option that prevents text from
covering the adjacent cell.
For example if I type the folling in cell A1:
All I want for Christmas is my two front teeth.
Obviously that will overflow over the cell B1 (if there
is no data in B1). I don't want to resize my column, I
only want the cell to show as much text in A1 as possible
without covering cell B1.
I believe I've seen the option to do what I'm looking for
but I can't seem to find it and I can't figure out how to
look it up in the HELP file.
Thanks in advance.
My simple solution ha...Convert Text to Number on 4,508 excel files.
I'm faced with a rather unique problem.I have a large amount of
improperly formatted excel files. They all have various cells formatted
as text, yet they contain numbers and perform calculations on the
cells. I now need to get these in a proper state.
What I need is:
Conversion of all text boxes containing numbers over to proper format
Do it automagically. I don't relish the thought of opening each one
individually and fixing it.
Any thoughts, tips or ideas on this?
It could possible if you process that works by Scripting .
In Scripting engine 5.6 Filesystem...Is Auto Expansion (i.e., wrap text) of a cell possible when the cell's contents are based on another cell?
I am trying to display the results from one tab (Tab 1) in another
So, for example, tab 2 contains the formula "=Tab1!A2".
However, when the results are too large to fit the cell in tab 2
(i.e., the cell that contains a formula that draws from a cell in tab
1), the wrap text feature does not work unless i first double click in
the cell in tab 2.
Is there any way around this? Can the wrap text feature work
automatically somehow? Or will i need to double click in every cell
that contains text that doesn't fit into the cell.
Thanks for any suggestions, or VBA code, th...Conditional text field Total
In the detail section of a report I have a text box that based on a condition,
it will be either a 0 or a 1.
I want to total the control at the end of the report. I did this in another
report a couple of years ago but it is not working now.
In the previous report, the ControlSource of the total is =
[TextBoxNameFromDetailSection] and it sums correctly.
What am I doing wrong??
Message posted via AccessMonster.com
Thanks but I see what was missing - "running sum over ...The opertion failed. An object could not be found
Outlook 2003, XPSP2
When I click on an email link (on a web page for example) I get the above
mentioned error message and nothing happens.
Could this have happened after importing saved settings from the same
machine (after a reformat/reinstall)? After doing this, I had an error
where outlook was looking for Outlookmail.FQDN.com-00000012.pst (could not
I don't use PST files, but rather an connected to Exchange - even though I
have 2 POP3 accounts configured in Outlook.
This happens on 2 machines on which I have imported settings. No other user
on these machin...Importing Unicode Text File
I have a CSV (comma seperated) text file. The text in
this file is Unicode (UTF-8). I can open the file in
Notepad and, if I use a Unicode font, see the characters
are correct in my text file.
However, when I try to open this in Excel, it gets mangled-
-the Japanese characters get converted into jibberish.
I've tried opening a blank file, then using "Import
External Data", but the Japanese characters in the file
still wind up getting corrupted.
What's BETTER is to change the "File Origin" to something
other than my default of Windows(ANSI) to someth...Business Portal 2.5 -- Linking 3 Web Parts
Can someone tell me if this is possible, I have been working on it and can't
seem to get it to fly.
I have my 1st web part that shows inventory master item information and a
few fields off of the item card. This drives a 2nd web part that shows
summary inventory information on that item by site. This works fine.
What I want to do is tie a 3rd web part in that gives me detailed
transaction information for that particular site (the 2nd web part). This
3rd web part works fine on it's own but shows all transactions for all sites
for all items by default. I have tried ...text box outline
In my text box, I can click on the text and a square dotted blue line that
surrounds the text. I can then click on some other text and the same thing
happens. How can I remove the Blue line. It seems to be in the edit mode
but I have even saved it and locked it (protect) mode. Still has to blue
outline. Help! and Thanks
The dotted blue line is to show you the Text Box boundary for when you don't
have a printable formatted and View Text Boundaries are set to OFF. Does
pressing the ESCAPE key hide them? But they should clear when you move the
cursor elsewhere. If they...