Over 1 million tech questions and answers.

Replace HTML format tags in Excel spreadsheet with actual formatting, ex: (),.;: etc

Q: Replace HTML format tags in Excel spreadsheet with actual formatting, ex: (),.;: etc

I have extracted data via sql from one application and need to upload it into a newer version of the same testing software. The problem: The data from the older version uses html tags for all formatting, when uploading the test cases to the new version, the tags load as literal text.

What I need is the formating to upload as it was formated within the older application.

Can anyone help? I am not a programmer.

Thank you.

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Replace HTML format tags in Excel spreadsheet with actual formatting, ex: (),.;: etc

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 83.2

Hello.

I haven't worked with Word scripts before and don't really know if this is possible, but from what I've read it should be.

Basically, I use a plain text editor when I write on my phone on the go, where I use HTML tags to indicate formatting like this:

Normal text <i>text I want italic,</i> some more normal text

Is it possible to create a script that makes words between <i> tags italic and then remove the tags? (same for <b> for bold and <u> for underlined text) and how would I record or write one?

And also, can I use one to remove blank lines?

I use Word 2010
 

A:Word macro to format plain text using HTML tags

I imagine you could write a macro to that checks this and does the appropriate action.

You will however have to establich the codes you will be using.

I don't know if there will be a conflict when you open word and depending upon the layout <i> might be interpreted before the macor runs, but I think it's a aquestion of trial and error,

<i> </i>
<b> </b>
<u> </u>
<rmv> </rmv>
etc...
 

Read other 1 answers
RELEVANCY SCORE 79.6

When I open an html file with Notepad I can see all the tags. How do I import html files into XL and have the html files appear in the XL cells with all the tags showing? I want to limit the number of lines I import into XL.
 

Read other answers
RELEVANCY SCORE 79.6

I am trying to enter a whole number that looks like this "123" into a cell and have it look like this "00123". I've even tried to custom format it and I can't get it to work. Please help
 

A:Solved: Need help formatting Excel spreadsheet

Hello smeegle, select the cells that you want to format and the on the main menu select Format>Cells>Number>Custom
and type in the box
00000
this will give you the format that you have shown.
 

Read other 2 answers
RELEVANCY SCORE 77.6

Hi everyone, I was having some trouble with the format of the date in my excel document.

Basically what i want to do is type in for example todays date (Aug 18), and then when clicking below onto the next row, I would like to see the date come up above as (08/18/2005).

Instead the problem im getting is the date comes up as (08/18/2018)????

Ive tried right-clicking the entire column, where the date is being entered, and using "Format Cells" to set the appropriate date format. I have also verifed the date is set at 2005, so far nothing works.

I welcome any ideas/suggestions???

Thanx everyone
 

A:Solved: Trouble formatting date in excel spreadsheet

Read other 10 answers
RELEVANCY SCORE 76

I am needing to convert an Excel spreadsheet to ASCII format.

I am hoping someone can help me.

Thank you
Danell
 

A:Excel spreadsheet into ASCII format

Hi Danell, and welcome to TSG.

MS-Excel allows you to export the contents of an Excel spreadsheet as tab delimited text files and also as comma delimited text files. Each row in the sheet is a line of text and either tabs or commas separate each column. If this is not what you are seeking, please provide a more detailed explanation of what you mean by ASCII format.
 

Read other 2 answers
RELEVANCY SCORE 75.2

All,

Ok, I feel like the Terminator...I'm Back!! I have yet another raw excel spreadsheet that I need some code to format so that I can import it into an existing Access table. Since the Access table is already existing, I would really just like to be able to run a macro and format this one before importing. You all have been a great help, and I have been learning, but this one I just can't crack...maybe because the raw format seems so scrambled to me.

I have posted the Unformatted and "Formatted" versions of the document. I would like a code to get from the unformatted to formatted version. The formatted version was done manually, but the unformatted version is so much longer it would take forever to do manually.

If you have any specific questions please feel free to reply and I will give anything needed to get this done.

Thanks to all in advance.
 

A:Needing Code to format Raw Excel Spreadsheet

Read other 16 answers
RELEVANCY SCORE 74.4

I have been given additional responsibilities and am out of my depth. I consider myself comfortable in excel, but not proficient. It does seem there should be a way to more efficiently do this than enter the info in various places several times.

We have windows xp, 2000. Does anyone know of a software (free or very inexpensive) program that deals with this type of information management or can anyone help me set up a spreadsheet that will capture this info and allow me to run reports as needed?

Info:
We lease office space in small buildings/ĒstripĒ malls.
Rental Co S1 S2 S3 Staff Outside Balancing
Leasee Rate Comm Comm Comm Comm Bonus Sales Totals
ABC 269.55 50% 25% 25%
ABC2 100 50% 25% 25%
ABC3 57.25 %-SB %-SB 15
ABC4 330 %-OS %-OS 150.

Rents arrive at various times during month and to balance a deposit I need to take the info from Master Lease table and enter and spread those commission amounts.

It would seem I could do the master chart for our 200+ leasees, plug in dates rent received and sort to create commission spread on the deposited funds. Iím not sure how to create the correct formulas and then how to create deposit reports that will give me on-going monthly commission totals. Iíve tried including a Deposit received column and then sorting for the individual deposit spread, but it isnít working.

Any clue how to create a time-saving solution? Maybe a pivot table but I havenít done any but the most basic type.

In other words any advice would be appreci... Read more

A:Excel spreadsheet format for tracking lease commisions

Read other 16 answers
RELEVANCY SCORE 72

I am using Save As in Excel to save a worksheet in HTML format. Unfortunately there is a lot of additional formatting code attached to the HTML code.

I am then using the include file="excel.html" directive to pull the saved Excel html page into an shtml document.

The formatting code in the Excel html code is really messing up the formatting of the whole page. Does anyone know of any tools/filters that can be used to remove everything but the core html from these Excel generated files. If not it looks like I may have to re-type the whole worksheet into html. :-(. Any other thoughts, or ideas are welcome.

Thanks in advance for any help and suggestions
 

Read other answers
RELEVANCY SCORE 71.6

HTML file for reproducing:
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<label for="pet-select">Choose an item:</label>
<select name="list" id="selectId">
<option disabled value="text hello">Item 01</option>
<option value="item02">Item 02</option>
<option value="item03">Item 03</option>
<option disabled="Redundant value" value="item04">Item 04</option>
<option value="item05">Item 05</option>
</select>

<br>
<button id="btnId" onclick="getInfo()">INFO</button>
<br>
<br>
<div id="resultId">RESULT</div>

<script>
function getInfo(){
var selectCtrl = document.getElementById('selectId');
var options = selectCtrl.options;
var textCtrl = document.getElementById('resultId');

for (var i = 0; i < options.length; ++i){
var option = options[i];
var tmpTxt = '\n//=====\n';
tmpTxt += 'option.attributes: ' + option.attributes + '[' + i + ']\n';
tmpTxt += 'option.text = ' + option.text + '\n';
tmpTxt += 'option.disabled = ' + option.disabled + '\n';
tmpTxt += 'option.hideFocus = ' + option.hideFocus + '\n';
tmpTxt += 'option.spellcheck = ' + option.spellc... Read more

Read other answers
RELEVANCY SCORE 70

Hi, I would like to generate an email from Excel in HTML format. This is what I have:

Sub Send_Email_Using_VBA()
Dim Email_Subject, Email_Send_From, Email_Send_To As String
Dim Email_Body, Mail_Object, Mail_Single As Variant
Email_Subject = "Trying to send email using VBA"
Email_Send_From = "[email protected]"
Email_Send_To = Range("Q14").Text
Email_Body = Range("Q15").Text & Chr(13) & Range("Q17").Text
On Error GoTo debugs
Set Mail_Object = CreateObject("Outlook.Application")
Set Mail_Single = Mail_Object.CreateItem(0)
With Mail_Single
.Subject = Email_Subject
.To = Email_Send_To
.Body = Email_Body
.Display 'enable this when you want to preview the message first
'.send
End With
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub

I have several cells in the sheet that I would like to populate in a email. I would like to define hyperlinks, font and font size. this code just puts the cell data as text.I believe this might be a good solution here http://www.dicks-clicks.com/excel/olSending.htmUsing

Using HTML in Message Body

Sub SheetInBody()

Dim olApp As Outlook.Application
Dim olMail As MailItem

Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)

With olMail
.To = "[email protected]"
.Subject = "Table in body"
.HTMLBody = SheetToHTML(ThisWorkbook.Sheets(1))
.Display
End With

Set olMail = Nothing
Set olAp... Read more

A:Email from Excel in HTML format

Ok, now I'm getting somewhere. this bit of code does the trick.

Sub SendRange()
'Sends a specified range in an Outlook message and retains Excel formatting
'References needed :
'Microsoft Outlook Object Library
'Microsoft Scripting Runtime
'Dimension variables
Dim Email_Subject, Email_Send_From, Email_Send_To As String
Dim olApp, olMail, FSObj, TStream As Object
Dim rngeSend As Range, strHTMLBody As String
Email_Subject = Range("Q6").Text
Email_Send_From = Range("Q5").Text
Email_Send_To = Range("Q7").Text
'Select the range for the body to be sent
On Error Resume Next
Set rngeSend = Range("Q8:Q16")
If rngeSend Is Nothing Then Exit Sub 'User pressed Cancel
On Error GoTo 0
'Now create the HTML file
ActiveWorkbook.PublishObjects.Add(SourceType:=xlSourceRange, Filename:="C:\tempsht.htm", Sheet:=rngeSend.Parent.Name, Source:=rngeSend.Address, HtmlType:=xlHtmlStatic).Publish

'Create an instance of Outlook (or use existing instance if it already exists
Set olApp = CreateObject("Outlook.Application")
'Create a mail item
Set olMail = olApp.CreateItem(olMailItem)
'Open the HTML file using the FilesystemObject into a TextStream object
Set FSObj = CreateObject("Scripting.FileSystemObject")
Set TStream = FSObj.OpenTextFile("C:\tempsht.htm", ForReading)
'Now set the HTMLBody property of the message to the text contained in the TextStream object
... Read more

Read other 1 answers
RELEVANCY SCORE 63.6

Hi, all.
 
I hope this is the correct area for this. My previous thread was moved, despite me not being in a business and it being an alternative programme I was using.
 
Anyway, I have some HTML code I would like someone to have a look at for me. It is telling me </BODY> and </HTML> are in error. I looked carefully and saw one of the blockquote tags is in red. I tried using paragraph tags inside this particular quote block to no avail. I also used "</BR>" and "< /BR>" which also didn't help. (Someone told me the space is required in the break tag, which doesn't make sense to me. It shows them in red, so I went back to using "<BR>" instead.)

<HTML>
    <HEAD>
        <TITLE>Rules</TITLE>
    </HEAD>
    <BODY>
        <CENTER><H1>Rules</H1></CENTER><BR>
        <BR>
        <P>These should be understood and followed while using this forum, and you can help to combat these:</P>
<BR>
<B>Trolling</B><BR>
<BR>
<I>Definition</I><BR>
<blockquote cite="https://en.wikipedia.org/wiki/Internet_troll">
a person who sows discord on the Internet by starting arguments or upsetting people, by posting inflammatory, extraneous, or off-topic messages in an online community (such as a newsgroup, forum, chat... Read more

A:HTML Closed Tags in Red

Try adding this line at the very top of the page just before the opening HTML tag. This is a document type definition. The error may be caused because this is missing. The way it is now whatever is validating this html would assume it's HTML5. Some of the html tags in the document are no longer part of of the current HTML specification. Adding this statement tells the validator that the page is HTML 4.01.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 There's a free HTML validator available at: https://validator.w3.org/check

Read other 5 answers
RELEVANCY SCORE 63.6

Hi, all.
 
I hope this is the correct area for this. My previous thread was moved, despite me not being in a business and it being an alternative programme I was using.
 
Anyway, I have some HTML code I would like someone to have a look at for me. It is telling me </BODY> and </HTML> are in error. I looked carefully and saw one of the blockquote tags is in red. I tried using paragraph tags inside this particular quote block to no avail. I also used "</BR>" and "< /BR>" which also didn't help. (Someone told me the space is required in the break tag, which doesn't make sense to me. It shows them in red, so I went back to using "<BR>" instead.)

<HTML>
    <HEAD>
        <TITLE>Rules</TITLE>
    </HEAD>
    <BODY>
        <CENTER><H1>Rules</H1></CENTER><BR>
        <BR>
        <P>These should be understood and followed while using this forum, and you can help to combat these:</P>
<BR>
<B>Trolling</B><BR>
<BR>
<I>Definition</I><BR>
<blockquote cite="https://en.wikipedia.org/wiki/Internet_troll">
a person who sows discord on the Internet by starting arguments or upsetting people, by posting inflammatory, extraneous, or off-topic messages in an online community (such as a newsgroup, forum, chat... Read more

A:HTML Closed Tags in Red

Try adding this line at the very top of the page just before the opening HTML tag. This is a document type definition. The error may be caused because this is missing. The way it is now whatever is validating this html would assume it's HTML5. Some of the html tags in the document are no longer part of of the current HTML specification. Adding this statement tells the validator that the page is HTML 4.01.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 There's a free HTML validator available at: https://validator.w3.org/check

Read other 6 answers
RELEVANCY SCORE 62.8

Hi,
I wish to use a 3rd parties website from within my VB program.
Basically it has an input box for a date and a submit button, the site then sends you to the relevant page.

My question is:
How do I duplicate what the <FORM> tags do on that site in my VB program?
In other words how do I send a date (or any data) to the targeted script via VB?

Thanks to anyone who can help.
Phil.
 

A:Duplicating html <FORM> tags in VB6

It is not really clear what you want to do. Explain it in some more details.
 

Read other 1 answers
RELEVANCY SCORE 62.8

Dear macropod,

Split from: insert html tags into word document

I've never dealt with macros before and trying to do this myself is making my brain melt haha.

However i need it ONLY for files that are opened, not located.

Also is there a way to turn it on and off if it is automated?

Could you please help?

A:Parse HTML tags in Word

For that you could use:

Code:
Sub UpdateOpenDocuments()
Application.ScreenUpdating = False
Dim wdDoc As Document
For Each wdDoc In Documents
With wdDoc.Range.Find
.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = True
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
.ClearFormatting
.Font.Bold = True
With .Replacement
.ClearFormatting
.Text = "<b>^&</b>"
.Font.Bold = False
End With
.Execute Replace:=wdReplaceAll
.ClearFormatting
.Font.Italic = True
With .Replacement
.ClearFormatting
.Text = "<i>^&</i>"
.Font.Italic = False
End With
.Execute Replace:=wdReplaceAll
.ClearFormatting
.Font.Underline = True
With .Replacement
.ClearFormatting
.Text = "<u>^&</u>"
.Font.Underline = False
End With
.Execute Replace:=wdReplaceAll
End With
Next
Set wdDoc = Nothing
Application.ScreenUpdating = True
End Sub

Read other 12 answers
RELEVANCY SCORE 62.8

Let's say I send a mass email to all my friends. Obviously, they would all have different email accounts, providers, browsers etc etc. If I put those special html tags on them, will everysingle person be able to view it??? I"m not talking about just the <b>bold</b>, or <i>italics</i>. I mean those other things that you don't see to often, such as <s>strike</s> and
<marquee ALIGN="Top" LOOP="infinite" BEHAVIOR="slide"
<BGCOLOR="#FF0000" DIRECTION="left" HEIGHT=30 WIDTH=200>
moving marquee tags too.
</marquee>.

I use yahoomail, and there is a function in yahoo to "allow html tags." I did that, and sent an example to myself. It worked fine. What about other mails, such as Outlook, hotmail, etc etc etc. Are there any limitations this? Will everybody be able to see the effect??
 

A:Does HTML tags work on email??

Read other 14 answers
RELEVANCY SCORE 62.8

Hello,

I use the Cute Html Editor to create web pages and lately, the .jpg .gif .bmp extentions arent there at the end of my files when I view them in the program. I have to re-add the extentions every time I rename anything, etc.

Can anyone please tell me how I can set it to show the file extensions? I tried going to Control Panel/Folders but I couldnt find anything there for that.

Claudia
 

A:VIEWING .JPG .GIF tags in Html Editor

To show File Extensions in Windows Explorer

Open any folder.
Press ALT and go to the tools menu
Open Folder Options
Go to the View Tab
Uncheck "Hide File extensions for known file types"
Hope that's the answer to the question you were asking.
 

Read other 1 answers
RELEVANCY SCORE 62

I've got several hundred word documents that I need to do some formatting on. I need to go through them and insert html tags into the document as per below...

a short bold text line

becomes

a short < b >bold text< / b > line

Minus the spaces of course.

At the moment I really only need bold, italic, underline, and unordered lists.

Does anyone know of the easiest and most efficient way of doing this? (Or some macro code?)

I don't have much experience in Word, but currently looking at writing a macro.

A:insert html tags into word document

Hi,

You could use a macro like the following. It processes all file in the selected folder.

Code:
Sub UpdateDocuments()
Application.ScreenUpdating = False
Dim strFolder As String, strFile As String, wdDoc As Document
strFolder = GetFolder
If strFolder = "" Then Exit Sub
strFile = Dir(strFolder & "\*.doc", vbNormal)
While strFile <> ""
Set wdDoc = Documents.Open(FileName:=strFolder & "\" & strFile, AddToRecentFiles:=False, Visible:=False)
With ActiveDocument.Range.Find
.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = True
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
.ClearFormatting
.Font.Bold = True
With .Replacement
.ClearFormatting
.Text = "<b>^&</b>"
.Font.Bold = False
End With
.Execute Replace:=wdReplaceAll
.ClearFormatting
.Font.Italic = True
With .Replacement
.ClearFormatting
.Text = "<i>^&</i>"
.Font.Italic = False
End With
.Execute Replace:=wdReplaceAll
.ClearFormatting
.Font.Underline = True
With .Replacement
.ClearFormatting
.Text = "<u>^&</u>"
.Font.Underline = False
End With
.Execute Replace:=wdReplaceAll
End With
wdDoc.Close SaveC... Read more

Read other 9 answers
RELEVANCY SCORE 62

Hi,

I saved an email in a personal folder with some plain text like username/password details.

When I open the email today, it all turned to lot of html tags and I see my text is inside the html tags.

How to change back to plain text?

Read other answers
RELEVANCY SCORE 62

Hi,

I saved an email in a personal folder with some plain text like username/password details.

When I open the email today, it all turned to lot of html tags and I see my text is inside the html tags.

How to change back to plain text?

Read other answers
RELEVANCY SCORE 62

I previously used Firefox, but had some problems connecting to a couple of my favourite websites. They'd just be interminably slow to open and it became a huge annoyance.

So I recently installed Opera 10 and am just getting to grips with it, fixing some annoying defaults (like Password Manager).
I've come across a couple of niggles, and wonder if anyone here can help.

First problem occurs when posting / editing / quoting messages on internet forums. In Internet Explorer and in Firefox, I can see rendered images, smilies and text formatting as I'm writing. I can use CTRL + B to bold etc.
Using Opera, images don't appear - I just see the image's address inside [ IMG ] [ /IMG ] HTML tags. Smilies and text formatting, the same.

This means I have to Preview messages to make sure things look as I intend them to. This is awkward when there's a lot of formatting in a message.
Is there a way to make Opera show images and formatting in forum posts whilst I'm editing, not just after I've posted?
The second issue is to do with the wee icons next to my bookmarks. I have everything checked under Delete Private Data, but unfortunately this deletes the bookmark icons too.
I'm wondering if I uncheck "Clear bookmark visited time" if this would retain the icons? And what exactly is "bookmark visited time"? I don't want to retain any sort of log of when I or other users of the PC visited particular websites, especially ... Read more

A:Opera 10: HTML tags and bookmark icons

Anyone?
 

Read other 3 answers
RELEVANCY SCORE 61.6

HELP. Running xp home/HOTMAIL. Have now received 2 .txt files from MExico. They download and they open but when they open i see a whole bunch of email addresses, html and body tags and somthing that says MIME format and then thousands of lines of code. The latest email file from MExico was called fotoshistorica.txt which i think means historical photos. I tried opening it in a picture viewer app but nothing. Opening it in any text editor gives me the above. Any help would be appreciated. Also i am getting from my friends in Mexico that they cant open a lot of my attachments. Is that country set up different for emails and stuff and attachment opening? Again any help is great. AND THANKS FOR TAKING THE TIME!!!!!!!!

Part of file----

Subject: Fwd: RV: Rv: RV: FOTOS QUE HICIERON HISTORIA
Date: Thu, 7 Jun 2007 19:41:24 -0500
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_NextPart_000_000B_01C7A9BC.6B25BE90"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
Thread-Index: AcepZb/rcm4A6LbgQlyPweDPMImFlQ==
x-originating-ip: [206.190.49.179]
x-ymail-osg: xe_DCgMVM1m8Bq7mvegPYyBcySx0sHy8UwQLj53t
x-apparently-to: [email protected] via 209.191.68.230; Thu, 07 Jun 2007 17:41:29 -0700
x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.3028

This is a multi-part message in MIME format.
 

Read other answers
RELEVANCY SCORE 61.6

Hey, I was wondering. . . is there a way to add an image using HTML with an open and a close tag. I cant use the normal <img src>.

Is there a way to insert an image using two tags?

Thanks guys

A:Insert image with HTML using open and close tags?

Can you explain a bit more what yer trying to do?

Read other 8 answers
RELEVANCY SCORE 60.8

Right now, clicking bold gives me the html tag for bold. I have no idea how I managed to turn on this... feature.

Could someone tell me how to turn it off? Thank you!
 

A:MS Word 2000: clicking bold is giving me html tags--help?

Try this, don't know if it will work or not but go to tools, options and on the view tab make sure there is no tic in the Field codes.

Second check the view you are in. Sounds like you are in viewing the htm source as listed under view.

Are you seeing all the htm tags or just the one for bold?
 

Read other 2 answers
RELEVANCY SCORE 60.4

Sorry, posted in wrong section.

Mods, please delete.

Woopsie!!!
 

Read other answers
RELEVANCY SCORE 60

I am entering $50.50 into a cell and 001 into others. Excel 2003 changes the $50.50 to $50.5 and the 001 to simply 1.

How do I change it so that it always retains the entries exactly as I typed them in?
 

A:Formatting Cells in a Spreadsheet

Read other 11 answers
RELEVANCY SCORE 59.6

I am in the process of learning webdesign, starting with HTML and CSS.

I want to be able to drop a spreadsheet file into my webpage's dir and reference a range of cells to show on a page in my website. I would like it to be able have the page reference the spreadsheet each time it (the page) is loaded by a browser.

What I would like to do with this is keep track of a FF survivor pool in a spreadsheet and allow the participants to view the pool results on a page on my site. I would like to just be able to upload the spreadsheet after updating it, and not have to edit the html page every time.

What language would be able to do this? Is this a Javascript function, or is it some other language? I have not started learning JS yet, but plan to once I have a firm hold on CSS.

Also, is there an ideal file format for the spreadsheet? Will .xls work, or should I make it .csv, or even save it as .xml with OpenOffice?

Thanks in advance...

-tim
 

Read other answers
RELEVANCY SCORE 59.2

Hi,

Does anyone out there know how to protect ONLY the formatting of an MS works spreadsheet. By this I mean I would like to be able to edit (cut and paste etc.) only the values in the cells and not the formatting. e.g if I have two cells one with a blue border and containing the value 1 and the other a red border containing the value 2. I would like to be able to select the first cell then hit copy, then select the second cell and hit paste. The result I would like would be two cells now both containing the value '1' but still retaining there original border colours, what I am getting is two cells containing '1' but now both have blue borders. i.e. when I hit copy on the first cell it copies not just its contents but also its formatting. Is there anyway that I can lock the formatting so that copy and paste operations only affect the cell contents. I ask as I have created a quite complicated template for accounting with a lot of varied formatting on different cells and I would like to be able to cut and paste values between any pair of cells without altering the formatting.
 

A:Protecting formatting in MS works spreadsheet

Instead of cutting and pasting by clicking the cell in the worksheet: select the cell, double click the contents in the formula bar, copy/cut, click the new cell, paste. You can cut down on the time by right clicking too.

OR

do your copy as normal, right click on the cell you want it to go into, select Paste Special and choose only what you want pasted. You can paste in the 'values' and not the formatting.
 

Read other 3 answers
RELEVANCY SCORE 59.2

How can I format an Access report to look like a spreadsheet?

It is cuurently formatting like this:

Location
Task
Hours

Location
Task
Hours

I would like this layout.

Location Location Location
Task Task Task
Hours Hours Hours

I know there has to be a way to do it without exporting to Excel.
 

A:Solved: Formatting Access to spreadsheet look

Read other 9 answers
RELEVANCY SCORE 58.8

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?

Leanne
 

A:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?

 

Read other 3 answers
RELEVANCY SCORE 58

I'm trying to Merge an Excel spreadsheet to Outlook and provide alerts for critical dates in said spreadsheet in the Outlook calender !
 

A:Excel - Merge Excel spreadsheet to Outlook with Alerts

Welcome to TSG faithtronic.

I've never done it but your thread has been setting here a while. A method to do this here http://www.ehow.com/how_5685419_create-calendar-excel-data.html

I would start with a couple of dates so not to screw up the whole calender! There are some sharper excel folk on this site that might provide a better answer. But this is a starting point?
 

Read other 1 answers
RELEVANCY SCORE 58

Hi
I am trying to export data from word or excel form into a spreadsheet. I have tried the macro at http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html and it worked for all text fields but not the drop down list options that I have in my form. Can anyone please help/

I have never done this before, hence the struggle. Any help would be much appreciated.

I attach the word form and the excel form which also includes the excel spreadsheet that will collate the data for analysis.

I would prefer the form in word and have it set up as that indicated in the forum thread above but picking up the data from the drop down lists as well.

Thanks
LAD786
 

A:Export data from word or excel into Excel spreadsheet

Hi there, welcome to the forum.
It seems this post you added on August 12th hasn't given you much answers.
You mention the two files, OK, But what I don't understand
I am trying to export data from word or excel form into a spreadsheet. ...
Click to expand...

You probably forgot to attach the macro's with it, that is if you did anything with the link you mentioned.
If you could attach the files with the macros, I could take a look and see what I can do for you.

Another thinng From Word or Excel.

Which one is it going to be?
 

Read other 1 answers
RELEVANCY SCORE 57.2

I have a massive .mp3 and .wma music collection and I want to put all the ID tag information (Artist, Title, BPM, Genre, etc.) into a .CSV, text delimited or Excel spreadsheet into respective fields or cells.

Can anyone advise of such a program (freeware preferred but willing to pay for a good quality one)?

Thx.

A:ID Tags to Excel

Explorer view (details) gives you all that and more...as will various players.

I thought about doing such with my music once...and then realized that it really serves no purpose for me...unless I just wanted to play with MS Access all the time. It's a lot simpler to just put all music in one folder/directory...set the view...and update it as I add new music.

I guess that I have to ask...what purpose will this new database serve? I mean...what will it provide you that you cannot already obtain by using Explorer view, combining files, etc. in Windows?

Louis

Read other 1 answers
RELEVANCY SCORE 56.8

I am making a new inventory sheet for work and i have a format problem I can't seem to fix.. It is only one box that will not show properly. Orginaly is wanted to put a whole date in the box but I changed it to general but I can not get it to look like the other boxs along side of it.
What do I need to do to fix it?
Also how to remove the dots along the header there.

puter hater

(Microsoft works spreadsheet)
 

A:messed up format spreadsheet

Read other 6 answers
RELEVANCY SCORE 54.8

Hi,

After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.
 

A:Solved: Excel 2007 spreadsheet gets error "Excel cannot open the file .xlsx.." How ca

https://support.microsoft.com/en-us/kb/820741

and 5 ways are shown here http://www.wikihow.com/Recover-a-Corrupt-Excel-File
 

Read other 2 answers
RELEVANCY SCORE 54.8

Good morning,

Looking for a strategy to produce a drill down capability in either Access 2003 or Excel 2003 that is limited to the standard installation (i.e. no add ons -- such as Smart Tags).

I recommended Microsoft Project, but the project sponsor is not open to this option.

Though the sponsor is still developing the specs, the data will arrive in a microsoft comma-delimited (.csv) format (yes .xml would be better) with at least 4 levels of hierarchy. Not all hierarchies will go that deep, others may go deeper. (i.e. some may be only 2 or three levels, others may go to 5 or "n" levels).

I'm willing to use pivot tables, but I don't believe they will nest.

I'm willing to use Access Forms, but I believe they only go down to one sub-form.

I have used VBA, but it's been awhile.

Any ideas?

Much appreciated: Grnadpa Brian
 

A:Solved: Access/Excel Drill Down no Smart Tags

Read other 7 answers
RELEVANCY SCORE 54

I started logging my miles for work and stuff. I want to make it count two different sets of miles. The first bot I have is total miles, which is expressed as =SUM(I6:I35) I want a second one, I just don't know how to make it work.
 

A:Excel Spreadsheet

Read other 9 answers
RELEVANCY SCORE 54

Hi,
I have a question about excel 97
I'm setting up an excel spreadsheet for a Reading Teacher.
She needs 4-columns called Names,Hearing/Sounds, Stanine, and
Writing/Vocabulary.
The question I have is the columns called (Writing/Vocabulary) and
(Hearing/ Sounds)will have scores and the teacher would like to click on Desceding or Acsending and sort the scores to see which student needs more help by checking lower scores.
How do I do that so that the scores will move with the names when she sorts them?
Any help would be greatly needed.
thanks walk12
 

A:Excel Spreadsheet help

Hi walk12,

If the data is selected from those specific columns, you can go to Data -> Sort, you should be promted to Expand the selection (I believe this is in 97). If not, select all 4 columns, Data -> Sort, Sort by Hearing/Sounds (or whatever). This should do it for you. There are also formula solutions to do this instead of sorting. Just depends on how much you want to manipulate your data. HTH
 

Read other 3 answers
RELEVANCY SCORE 54

Excel spreadsheet not auto updating. What can I do other than hitting f9?
 

A:excel spreadsheet

try open excel,click on the tools menu,click on the calculations tab and set the radio button to automatic
 

Read other 2 answers
RELEVANCY SCORE 54

Attached is a file where I need to allocate the dollar amount. I need to allocate the dollar amount, proportionately, from cells C84 & D84 (Management Volume Challenge) across the values in each of the columns C3, D3 through C72, D72(SINGLES and KIND SIZE). Cell F84 is the area where the dollar value for a reduction or increase. The row items in BOLD are summary lines and do not require an allocation of dollars.

Thanks for your cooperation in advance.
 

A:EXCEL spreadsheet

Nothing is bold. It's a TXT file.
Try uploading the file again.
This time, do not SAVE it as a text file.
Instead, copy your file, change the file extension from xls to txt using Windows Explorer and not Excel.
Then load it.
 

Read other 1 answers
RELEVANCY SCORE 54

Can somebody help please. Have a spreadsheet something like this

DATE DATE DATE
CM789 Y L Y
CF897 Y Y Y
CM856 L L Y
CM742 Y Y Y
CF7854 L Y L

TOTAL 3 3 4

What I am trying to achieve is to get a total by either CM or CF for each date
ie

CM 2 1 3
CF 1 2 2

Can somebody help please
 

A:Excel Spreadsheet

Read other 7 answers
RELEVANCY SCORE 54

Hi there,

I am going to try to word this as simple as possible, but i am having trouble coming up with a formula to work between TWO worksheets, and i am not even sure it is possible.

Basically these two worksheets contain similar data, however, only one of them is updated, and i would like the other worksheet to populate itself based on what is entered on the first worksheet.

I have figured out how to do this using IF statements, however, as new data is entered into the first sheet, i would have to continuously build IF statement formulas.

My question is, is there a way to make a formula based on the following that would work absolutely (When you drag it down changing per row it would display the data i need):

WHEN data in column one, matches data in column one on sheet 2
AND
Data in column three match data in column 3 on sheet 2
THEN
display data in specific cell on sheet 1 to specific cell on sheet 2

I know that it seems simple to build an IF formula, and nest it. But is there a way to build a formula that would search the entire sheet matching the data and displaying without having to build a specific fomula for each row?
 

A:HELP! with an Excel Spreadsheet

Hi Jake

Are you ever a candidate for Visual Basic for Applications (VBA), which comes for free with Excel. You can buy a book on it -- I got good value from the Weekend Crash Course book on the subject. However, you can also get started easily by recording macros and then editing them. There are tons of resources on the internet (google for VBA and Excel and whatever term you want help on) and the Help in VBA is also very helpful. One of my favorite websites on Excel is mrexcel.com. Bill Jelen (aka Mr. Excel) has written tons of articles and books on Excel and is one of Microsoft's preferred gurus, although he doesn't work for Microsoft.

To start VBA from within Excel without recording a macro, just hit Alt-F11 and start using it.

Have fun!

Jeremy
 

Read other 3 answers
RELEVANCY SCORE 54

Attached is a spreadsheet I have 2 questions on. I have read many posts out here but I haven't gotten any to work.

1. How do I remove the page # that appears on each page?
2. Is it possible to sort the contents of a single cell? I want to sort the following data that is in a single cell: Magellan, PrimeSource-GSH, UBH, Quest, Value Options, Intergroup, Cigna, CBHNP, CCBHO, Gateway Assured, Aetna, Highmark, Premier Blue, Freedom Blue, Unison, MH Net, LifeSynch, LifeSynch MC, Medicare

Any help would be much appreciated.
 

A:Need help with Excel spreadsheet

Read other 8 answers
RELEVANCY SCORE 54

I have a very large Excel table that I need to convert into an XML document to display on the web in various ways. I found a macro online that creates a very nice and clean XML document -- www.meadinkent.co.uk/myxml/XL_to_XML.txt
However the table has lots of external links and none of the link attributes come through to the XML.
Likely there are a variety of ways I could do this but my experience with Excel is very limited, so any advice would be greatly appreciated!

Thanks in advance!
 

A:Excel Spreadsheet to XML

Read other 16 answers
RELEVANCY SCORE 54

I am setting up a spreadsheet for my classes, and I am wanting to see if there is a way to sort a column by male, female pattern. (I was hoping to be able to sort the list that way in order to prepare a seating chart....boy, girl, boy, girl etc...)

...I know that it will sort it by lumping the males together and then the females or vice versa... But I am hoping there is a way to be able to alternate the boys and girls.

But before giving up I thought I would ask you all here, since you have been a big help in the past.

Thanks in advance!!!

=O)
KimlaiKy
 

A:Excel Spreadsheet

You could have another Column where you have numbers pairing them.
ie. Sort them Male/Female and then for the Males enter 1 for the first and 2 for the second and then drag that sequence down to the last male. The repeat that for the Females.
Now sort by value first and then m/f and you should have boy, girl.
I think.
Actually you get Girl, Boy etc
Make it G & B instead of F & M to get it as Boy Girl.

The column with the values can of course be hidden.
 

Read other 1 answers
RELEVANCY SCORE 54

Hi,
I have to import values into a website. This information is for electrical transmission flow. Based on the number of paths I have and the duration I select. I would like the spread sheet to create the lines for me and have them populate the correct field. I am attaching an example. The Por and Pod are the To and From. Currently in my spreadsheet I have 7 paths setup. If that changes though I would like it to automatically add the additional path in the correct place. I also show 3 hours for the duration, but this could be days or months and it might be broken up in hours days months. Example for Months it would be 7/18/2009 0:00 to 8/18/2009 0:00. I generally post 1 year of monthly values so on the Input page I was thinking about asking the user for the duration (Start to Stop times), Increment (hours, days, Months), and path names (To and From) and have excel create the attached worksheet with those colums filled in. I am not sure I have explaned the situation very clearly so if you have any questions please ask.
Thanks,
Joe
 

Read other answers