Computer Support Forum

Solved: ACESS: import excel field as text

Question: Solved: ACESS: import excel field as text

I have an excel file with a column with values like 100, 200, 500, 500-02, and 500-04.
Access wants the column to be a number because 500-02 is not one of the first records.

If I use the acImport or acLink I get the same results. Which is an error importing (I get all the data just not the text values in the column) or a null value in the link when view from Access (even though you can open the spreadsheet with excel and see the true data). If I use the import Wizard and change the Field to text it that data is fine.

I also tried acImporting to an existing table with the field set a text but it changes it back to numeric and screws up.

I have a vision impared user and I need a button click to get this data into access.

Thanks for reading my post.

Relevance 100%
Preferred Solution: Solved: ACESS: import excel field as text

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 (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Solved: ACESS: import excel field as text

7 more replies
Relevance 83.23%

Help Request: formula or macro to Import all text files (tab seperated text file) in one worksheet
(NOT as seperate sheets in one work book). [Excel 2013]

Thanks in advance

Answer:Solved: Excel: How to import multiple text files in single worksheet

11 more replies
Relevance 83.23%


Referring to the post with subject line "Solved: Excel: How to import multiple text files in single worksheet", which is already in solved state.
I had a doubt and so i have opened a new thread for this.
I have downloaded the first sheet attached in the post mentioned above and I have changed the file names in the sheet2. But of no result.
Here I just wanted to know the procedure of how to use this to import the data from text files.
Please help me here. Early reply is highly appreciated.
Thanks in advance for the help.

Nagasayana reddy J

Answer:Solved: Excel: How to import multiple text files in single worksheet

11 more replies
Relevance 79.95%

Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub

Answer:How 2 import text data into Excel from scanned text file ?

12 more replies
Relevance 77.49%

I know the Include Field will include part of the text from an Include File if it is in a bookmark. The format is {IncludeText "File Path" Bookmark}. I have 2 files: Source and Target.

Source is a form template. I included a Text Form Field and gave it the bookmark AA. I also included other text in a "normal" bookmark, BB.

In Target I have 2 fields: {IncludeText "C:\\" AA} and {IncludeText "C:\\" BB}. The text from BB shows up, but the one for AA is blank.

If I go into Source and look under Bookmarks, both AA and BB are there.

BTW, I have tried it with the Source form both "Protected" and "Unprotected" and it didn't make any difference.

Any idea why this is happening, and more importantly, any idea on how to make this work? If not, it seems like a real bug in Word 2003 as they are both definitely considered to be bookmarks.

Thank you,


Answer:Word 2003 - Include Text Field - Not Including Bookmark Text if in Form Field

Thread reopened for user to post solution.

3 more replies
Relevance 74.62%

running excel 2007 on a vista machine with vista sp1.

i created a new file, imported a text file into it. it worked fine for a few days and now everytime i import the text file it crashes as soon as the text file is imported into the screen. i've tried everything i can think of, deleting the link, disabling macros, copying everything but the link into a new spreadsheet.

nothing works!

any ideas?

More replies
Relevance 73.8%

I want to import into Word an Excel spreadsheet which contains text boxes. Using the Copy & Special Paste Function this works fine.However, the imported spreadsheet displays around 10 blank rows below the intended content. How can I prevent this?

Answer:Import Excel With Text Boxes Into Word

A hidden and unneeded text box was the culprit. Removed the box, re-saved the sheet, all is well.

1 more replies
Relevance 73.8%

I need help importing text database (for mailing lists) from ACT 4.0 to Excel 2000. However, I do not have ACT application on my computer, and am not able to work from the other (second) computer - person is using it all the time. Could someone help me with this, step by step somewhat. Should the person I'm doing this for save ACT file: on CD; could they email it to me, also?

Thanks for any help.

Answer:ACT 4.0 to excel 2000 -can i import text database?

Hi, and welcome to the TSG forum

can they export as a csv file (comma seperated)
then its simple
you just open it in excel.

3 more replies
Relevance 73.8%

Hi, I have made a macro to import text file into excel 2007 and that works fine. I would like to hide the particular sheet hidden,when it is being done,so that no one sees what it is being imported. Is that possible ? Manuel

Answer:Can I import text file into excel,when hidden

Why not share the macro with us so that we don't have to start from scratch?Please read the How To referenced in my signature line before posting the code.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 72.98%

When I import a Text file into Excel (through Data > Import External Data and go through the Wizard) the data comes across correctly in the right columns etc. - I'm ok doing that.

The numbers and/or currency in my data do not seem to "work" properly as when I try to do calucations (such as a simple autosum) the answer always comes back as 0.

I've tried re-formatting the data as numbers/currency but this doesn't help.

I've also tried multpiplying the numbers by 1 (using Paste Special) to get them to re-format but this doesn't help either.

Any suggestions?


Answer:Import Text file to Excel - number format

Hi there, welcome to the board!

They could possibly have leading and/or trailing spaces. A couple of ways to handle that. Download/install a free add-in called ASAP Utilities, which you can access from (assuming Excel 2003, which is what it sounds like) ASAP Utilities menu, Text, Delete leading and trailing spaces. The range must be selected first. Another way would be to write your own macro to do it. If you don't have ASAP I'd highly recommend it, as it gives you additional tools and resources not native to Excel, making your life in Excel much easier.

An easy way to check would be to use a blank cell (generally adjacent column) and enter the formula =LEN(A1), where A1 references the cell in question with your numbers. No doubt they're numbers stored as text. If you've done the paste special then there's nothing to force to numerics. The other way to do that would be to select everything and to Text to Columns (from Data menu), and just click the Finish button (not going through the Wizard), which will also force (coerce) numerics stored as text to numerics.


1 more replies
Relevance 72.16%


Does anyone know how to change the text import wizard default from tab to semicolon? TI is not hard to choose but some of our end-users are having difficulty. I thought if I changed the default it would help.


Answer:Change Delimter Default in Excel Text Import Wizard

7 more replies
Relevance 68.06%

I need a date field changed into a text field of YYYYMMDD so for example the date of birth field is 3/17/1953 and I need that converted to 19530317 in the Excel spreadsheet. Thanks.

Answer:I need a date field changed into a text field of YYYYMMDD

under the format options.

5 more replies
Relevance 68.06%

I support a software program that has a proprietary menu item when you right-click a calculated field. It has been this way for 10-15years and has worked in WinXP through Win10 with never an issue. This past week I had 3 different customers tell me that when they right-click one of these fields to access what is normally the Cut/Copy/Paste/ menu that also includes our menu item, they are now getting the Windows default cut/copy/paste/Right to Left Reading order/Show Unicode control characters/ etc menu. The only thing I can think of that they all have in common besides these are all Window 10 64bit pc's, is that they all have one update to Adobe Acrobat (17.012.20098).
I was able to resolve for a moment on two of these workstations by having the user go into Language/Advanced settings and actually selected "English (Unites States) from the "Override for Windows display language" even though that settings is implied by the "recommended". But after the pc was turned off over night and back to it the next day, the problem is back and that setting is still selected. All language and regional settings on all the pc's are defaulted to English/Unites States. I do not know what other avenue to go in. Could something hae been switched on or off in Windows (by this Adobe update perhaps?) that would make the context text menu switch to Windows text default right-click menu?

Any help is appreciated!

More replies
Relevance 67.65%

I was wondering if the following is possible:

I am using Microsoft Excel currently (on a Windows XP machine) and I have three columns, one is text (name) and the other two columns are MM/DD format (start date) (finish date).

Can I make something that will move the entire row to a new sheet/tab, after the second date is added?

Name Start Date Finish Date
ABC Company 07/11/07 07/15/07
BCF Company 07/15/07 _______

Any guidance with this problem would be greatly appreciated.

Thanks in Advance,

Answer:Solved: Moving text after completing a field

15 more replies
Relevance 67.65%


i want to update the text box based on the combo box selection based on the user form in excel. I am using the below code but the problem is combo box value is hidden once i selected but text box value is coming.
'Private Sub ComboBox1_Change()
'ComboBox1.Value = Worksheets("OptionPage").Range("Af28").Value
'TextBox7.Value = Worksheets("OptionPage").Range("Ag28").Value
'End Sub

I am assigning the value of combo box into af28 and from there i am doing a vlookup in ag28 to get a value. In the combo box i have row source of particular range in the sheet.

Please help.....

Answer:Solved: Combo box text field updation

Hi, could you just post a sample with dummy data, it makes it easer to 'see' what you need / want.

3 more replies
Relevance 66.83%

I thought I read somewhere that it was possible to do a search on a reserved character by putting "" around it. I made the mistake of annotating some appended text fields with "**" (without the quotes) so I would know which records had been added. At some point, I want to remove those two asterisks. . . but, of course, I suddenly realized that Access recognizes an "*" as a wild card meaning something/anything, not the "*" character. So a search using Like "***" or "*'**'" either finds nothing or finds every record with anything in the field.

So the question is, is there a way to search for a literal "**" in Access? OBP. . . are you home today?

Answer:Solved: Finding reserved character in text field

16 more replies
Relevance 66.42%

I created a form letter as an Access 2007 report. The only field is [first_name] from a query. The first line reads, "Dear Joe (or whatever [first_name] is). I want a comma after each name. I tried =Trim([first_name] & ","), =Trim([first_name) & "," and every combination I can think of. Every permutation returns Dear #Type!. How can I get Dear followed by the name and a comma? Thanks!

Answer:Solved: Access 2007 Trim and field text addition

14 more replies
Relevance 66.42%


I am currently using Word 2003 and have created a template. Within the template are text fields. My current issue is that if I make a change to formatting in one of the text fields, it replicates to all of the text fields. To give an example in the screen shot if I enter text then change the formatting under Point 1 (Project Statement) that change remains with that text field. If I go down to the next form field, and before entering any text, make formatting changes, that replicates to all of the form fields below. Similarly if text is entered first, then a formatting change made i.e. bullet point, that then seems to replicate through to the rest of the text fields. Can someone please explain as to why this is happening? thanks.

More replies
Relevance 65.6%

Running Outlook 2000 on Win2K.

Received an email with a large number of recipients in the "To" field.
Is there an easy way to save all of the addresses as contacts in my address book - preferably in a new folder so I can sort through them before adding to my main contacts.

Thanks in advance.

Answer:(Solved) Outlook - Import contacts from "To" field?

8 more replies
Relevance 64.37%


I'm having trouble extracting text from the middle of a text string using Excel.

I've been searching around and there are a few ways this can be done however most really on using a function to search for the text after a specific letter or seperator.
For example singling out the middle initial of a name:

Jeffery J. Skilling
John D Doe

In Column B the First Name will be extracted using the following formula
=LEFT(A2,SEARCH(" ",A2,1)-1)

in Column C the Middle Initial will be extracted. for middle init use this formula
MID(A2,SEARCH(" ",A2,1)+1,1)
My problem is that i can't single out anything to search by to be able to define what needs to be extracted.

Below is a list containing some of the items from my list. As you can see they differ in number of characters and have multiple dashes "-". What formula/process can i use to extract the bold numbers from each of the text strings. I have about 27000 lines to process!


Once again your help is always greatly appreciated!

Answer:Solved: Excel: Extract text from the middle of a text string - Difficult

"multiple dashes": agreed, but in your sample all items have the same number of multiple dashes -- 3.

If that's a given, just use Data > Text to Columns with "-" as delimiter. Then delete fields 1, 2 & 4 from the results since it seems that "section" 3 is always the bold stuff.

HTH, if not post back.

3 more replies
Relevance 64.37%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like


exit celll with ctrl, shift, enter

1 more replies
Relevance 63.55%

Hi, I need help with a macro. I want to copy the contents of the cell above into the cell below if the cell below is blank.

A1 1234
C1 5678
E1 2345

so it looks like this after the macro runs.

A1 1234
B1 1234
C1 5678
D1 5678
E1 2345
F1 2345

A1 is line 1 of column A. My apologies that I don't know how to copy an excel into my post.

Thanks in advance for your help.

Answer:Solved: excel help if field is blank copy contents


Is a macro absolutely necessary? This can be done by using a blank column and, starting in row 2 enter this formula


Copy this to the end of your list then copy the new column and PasteSpecial/Values to column A.

A few extra steps than a Macro but much easier to maintain. If you really need a macro let me know and we can whip something up.

2 more replies
Relevance 63.14%

Hi all, 
I have a matter about placeholder in html. The placeholder will be disappeared when focus
on text filed with IE. But I want to keep hint text of placeholder when do that. Could you give me any suggestion?

More replies
Relevance 62.32%

guess this could probably be any office app question......regardless......I've got a pretty good sized music library, and I've always maintained a spreadsheet that I pull from the drive the music is on with the following command line prompt:

dir /b /s *.mp3 > c:\music.txt

Once I get it into text, I can manipulate it with excel to my hearts content. All I want to add is the attribute switch to get the size and dates of the files, and I had thought that the /a switch would do that, but no go.

Any ideas?



Answer:Solved: random excel import question

15 more replies
Relevance 62.32%

I'm trying to create a macro to import a webpage on to an excel (2003) worksheet. The website is:

Everything I have tried (and tried, and tried) imports the text only without the gif's. It appears that the gifs might actually be individual links and that may be the problem. I do not need the links, just he pictures.

The following code is just the basic set up. I have not included any of my failed attempts as they are just that...failed stuff.

I did include within the code the urls for each individual gif as I think there might be a way to accomplish this using individual calls, but that seems like a lot of wasted time as there are 20 gifs on the page. I would prefer to open the page once and copy it to my sheet "S" in one shot. Or,open the site once and copy the individual pictures one at a time, as that would work also.

Any direction is appreciated.


Sub GetJetStreamSite()
Dim b As String
Dim PicAdd(20) As String
Dim Ie As Object
Dim x As Integer

'Create recieving sheet "S"
Application.DisplayAlerts = False
On Error Resume Next
On Error GoTo 0
Application.DisplayAlerts = True
ActiveSheet.Name = "S"

'Create indivual picture URLs, if needed
For x = 0 To 9
PicAdd(x) = "" & x * 12 + 12 & "_sfc.gif"
PicAdd(x + 10) = "" &... Read more

Answer:Solved: VBA Import web page into Excel 2003

Unless I am misunderstanding what you are trying to do you should just be able to open Excel and choose FILE >> OPEN and then enter the website URL into the filename text box and click OK or use the following macro command.
[B]Workbooks.Open Filename:=""[/B]
If you follow the steps above the entire webpage will be pulled into the Excel sheet including the pictures but as you indicated above the pictures are embedded hyperlink images. If you would rather have the pictures saved locally to your machine you can run the macro below which will save each image from the website and then edit the hyperlink to point to your local drive instead . Just change the portions in the code that are highlighted in red to reflect the correct URL of the page to download the images from and the save path on your local machine. Hope this helps!!
Private Declare Function URLDownloadToFile Lib "urlmon" _
Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, _
ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
Private Const ERROR_SUCCESS As Long = 0

Sub DownloadPics()

For Each vLink In ActiveSheet.Hyperlinks

vURL = "[COLOR="Red"][/COLOR]" & vLink.Address

vPic = URLDownloadToFile(0&, vURL, "[COLOR="Red"]C:\Test\[/COLOR]" & Mid(vLink.Address, InStrRev(vLink.Address, "/")... Read more

3 more replies
Relevance 62.32%


I reference an object (Monarch) to create a table that I then want to import into my Access Database. The file is outputted by default to a .xls extension and Microsoft Excel 2.1 Worksheet (I am using Office 2003). When the below command runs, I receive an error indicating that the file is not in expected format. I have tried all the "TypeExcel#"'s and haven't had any luck. Any suggestions?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblVendBO", strExportTable, -1
I also tried to rename the file into a .tab file, however, when I import that file, it is all jibberish.

Thank you,

Answer:Solved: Excel File won't import into Access

7 more replies
Relevance 62.32%

I wish to know if it is possible to update a field on one sheet with the last entry of another sheets column?

as info is added to one sheets column the data on the other sheet is automaticall altered to show the last entry in the first sheets column where i entered the data in the first place

Answer:Solved: EXCEL: update field on one sheet with the last entry of another sheets column

16 more replies
Relevance 62.32%

I've upgraded from Excel 2000 to 2007 and cannot get the pivot table field list to show. I activate the pivot table and switch it from hide/show either by right clicking or from the toolbar but still no joy. I''ve looked all over the spreadsheet to see if it hidden anywhere but cannot find it. Any suggestions? If it is hidden somewhere can I move it via vba code?

Answer:Solved: Excel 2007 Pivot Table Field List Missing

16 more replies
Relevance 61.5%

I have tried using a web query for what I am trying to do, and it just wont work. So I am wondering how I can copy an open webpage to excel automatically.

Answer:Solved: How do I import data from a webpage that is open to excel?

7 more replies
Relevance 61.5%

I have multiple .dat(more than 100) files with me . Each contains data as below (sample).

5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|10/1/2015|AOM|F||864.946|4.815|11/2/2015|5033
5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|11/1/2015|AOM|F||858.765|4.715|12/1/2015|5033
5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|12/1/2015|AOM|F||856.524|4.79|1/4/2016|5033
5/07/2014|YEMU Euro BOB OXY FOB Rdam Bg Mini|Abcdfr Futures|1/1/2016|FOG|F||860.039|6.172|2/1/2016|5033
5/07/2014|ZEMAL Euro BOB CAR FOB Rdam Bg Mini|Abcdfr Futures|2/1/2016|MIG|F||860.797|4.515|3/1/2016|5033
5/07/2014|ZEMAL Euro BOB CAR FOB Rdam Bg Mini|Abcdfr Futures|3/1/2016|ULM|F||859.065|4.099|4/1/2016|5033
5/07/2014|ZEMAL Euro BOB CAR FOB Rdam Bg Mini|Abcdfr Futures|4/1/2016|ULM|F||898.499|5.248|5/2/2016|5033
From this I want to create a dat file contains data for Licence ULM only.

Anybody please help

Answer:Solved: Import multiple dat file to single excel

12 more replies
Relevance 61.5%

Hi. I'm trying to make an excel sheet with a button that will prompt an import box ("open" window) where I can highlight 1-100 different files, and excel will read it and dump all of the data into its own sheet (one sheet per text file). Is this possible?


(edited for clarity)

Answer:Solved: Excel import multiple files via dialogue box


What version of Excel are you using. It makes a difference.

1 more replies
Relevance 61.5%

Tried doing this but I get scattered pieces imported.

Got as far as dragging address from an excel file to email field in Outlook, but get an error and bits and pieces.

Don't want to import one by one.

i shortened the excel file to just one column with e-mail addresses.

Got to be a way.

Answer:Solved: Import e-mail addresses to Outlook from Excel

Hi holymoly

In the Address Book in Outlook Express, enter at least one contact.

Then Export the Address Book as a Text File (Comma Separated Values) (.cvs) file to the Desktop.
This will give you a template to work with.

Open the .cvs file and paste the e-mail addresses into the correct field.
Save and close the .cvs file, then Import it into the Address Book.
File > Import > Other Address Book > Text File (Comma Separated Values) > Import
Browse to the .cvs file on the Desktop.
Let us know if that works for you or not.

2 more replies
Relevance 61.5%


I'm going to be importing ~150 separate .dat files into a single excel spreadsheet. The files have no headers, and I want them stacked on top of each other in the same columns. Each file is 18 columns wide and 640 rows long. Is there a way to do this that does not involve macros? I'm going to be doing this multiple times over the next few months and I would like to be able to do it myself, or at least modify the code. The files are numbered in an ordered, sequential fashion eg. KM070201000, KM070201001, KM070201002, etc.

I've tried a few solutions on the web for .txt files but they don't seem to work for my .dat files.


Answer:Solved: Import multiple .dat files into one Excel sheet
Any use?

3 more replies
Relevance 61.5%

Hello Helpful Folks,

I have searched with no luck for a solution to my problem. Here's the rundown:
Running Windows XP
Using Outlook 2007, Excel 2007

I want to take a database in Excel and import it into Outlook. Not sure if my screenshot is attached, but I do not have an option to "Import/Export" under File. Any other way around this?? Thanks for the help.

Answer:Solved: Cannot Import Addresses from Excel to Outlook 2007

6 more replies
Relevance 61.5%

I'm trying to import a contact list from Excell 2003 (11.80...) SP3 to Outlook 2007 (12.0) MSQ (12.0)
When I try to map the fields, I can only drag one "vlue" at a time, and when I I try to map another one, it seems to disapear. I went and maped all the fields, one at a time using the Map Custom Fields and it imported all the Excell fields into one Outlook field.
I'm useing Windows XP
I tried and tried all day, can somenoe help???

Answer:Solved: Can/t import contacts to Outlook 07 from Excel 2003

7 more replies
Relevance 61.5%

I have an excel spreadsheet which has names ( first and surname in single column under NAMES ) and email addresses (under EMAIL) which I want to import into my Outlook Personal Address book. I have followed advice of previous post but still only get the email addresses, no names. Tried suggestion of inserting a userdefined name for the spreadsheet but I still only get the option of email address in the import-from column. I have tried renaming the columns, I have tried changing them around. Is it because I don't have addresses and phone numbers?

Answer:Solved: Import contacts from Excel into Outlook 2003

8 more replies
Relevance 61.5%

Hi, I am looking for a macro to import contacts from excel. We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I would like to create the macro for all the team so that they can periodicaly update their contacts. I trust this makes sense
Moved to Business Applications.

More replies
Relevance 61.09%

I'm without any success hardly trying to modify (as begginer I'm still unable to create) some macro's I found in this forum in order to send data from Excel sheet into a specific public (or not if it's too heavy) calendar in Office 2010.
Import would take place with a push of a button and duplicates should not be allowed...

Even a simple line like: Dim olApp As Outlook.Application gives an error ...Maybe I'm getting tired...

And how should I modify those lines in order to select a specific Calendar (using Folder(Calendar name) in place of GetDefaultFolder in the lines mentioned here under?
Set olNS = OL.GetNamespace("MAPI")
Set olFolder = olNS.GetDefaultFolder(olFolderCalendar)

If someone would be kind enought to give me a help, here are some details about my Excel sheet:
Column A "Company", Column D "Date soon", Column G "Date Late"
Column A is fully completed, but columns D and G have some lines without any date...

More replies
Relevance 61.09%

I have a file that i import into access 2007 and i was wondering if i can take part of that file name and put it into a field in access? For example here is one example of a file name:


I have done some research on this but cant seem to find the answer when numbers change all of the time. I just need to grab the numbers on this file name. However, these numbers change all of the time. Does anyone have a solution for this? Thank you in advance. Any help and code is much appreciated i am very new to vba.

Answer:How to import part of filename into a field in access 2007

All I can think of is to write a vbsript that rewrites the file appending the desired part of the filename to each record(not to hard but another step). Better would be to have the creator of the file add the string to each record..

1 more replies
Relevance 59.86%

Hi. This is on the Customer (Patient) Details form, designed to call up the patient's blood test details by matching hospital numbers. Only trouble is, it doesn't. It pulls up only the blood test details from the first record in the database, and puts that in as a form in front of any correct form. Any idea why?

'Button VB text:'
Private Sub Blood_Test_Form_Click()
DoCmd.OpenForm "PD HI Blood Test", , , , acFormEdit, , "Me.Hospital_No_"
[Forms]![PD HI Blood Test]![Hospital No] = ([Forms]![Patient Details Form]![Hospital No])
[Forms]![PD HI Blood Test].FilterOn = True
End Sub

'Destination form (PI HI Blood Test) properties:'
Filter: [Hospital No]=Forms![Patient Details Form]![Hospital No]
Allow filters: Yes

Answer:Acess: VB button text

Hello, I could have sworn that I had that working for you.

2 more replies
Relevance 59.45%

I am migrating from an XP SP3 desktop to a Windows 7 64 bit machine. I use Outlook Express extensively on the XP machine, but have loaded Live Mail on the W7 one as the recommended solution.

I have experimented with the Import function in Live Mail using the .dbx files produced by OE held under 'Identities' but find that the Account field for each email (visible in Live Mail when the Account column is enabled) is not being populated in Live Mail. Am I doing something wrong, or is this a bug? I note that any new emails I receive do populate the Account field, and I am confident that the Account information is present in the .dbx files.

I would like to find a workaround for this problem - any ideas folks?

Many thanks

Answer:Live Mail import from Outlook Express - Account field problem

Quote: Originally Posted by runner bean

...the Account field for each email (visible in Live Mail when the Account column is enabled) is not being populated in Live Mail. Am I doing something wrong, or is this a bug?...

I suppose you could call it a bug. It seems to happen whenever you do an import using the "import/export" "wizards". Not just with OE>WLM but also WLM>WLM. (Same with Vista's built-in WM.) It's been too long for me to remember what happened when I last did OE>OE. Keep in mind that wherever an import/export is involved (even with contacts), some fields are lost.

2 more replies
Relevance 58.63%

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.

Answer:Solved: Access Auto-Populate a Field using a field from another table

15 more replies
Relevance 57.4%

I am not sure exactly the topic I need help with, but I geuss it is some sort of parsing.

I have data in colums. Day, Date, Time, location, and of course I was not thinking when I was setting the spreadsheet up.

The time column has multiple times in one cell. I need to take these times and split them into individual cells in rows on top of each other, and for each time put that date, day, and location next to it. For location, is there is only one location that means it applies to all of the times, for the others the location line corresponds to that lines time.

Right now there is only one day and date for many times, but once these times are split up there will be repeating days and dates and location for each time.

I have attached the spreadhseet, as I havn't done an excellent job of explaining. But I assume once you see it you will know what I mean.

Some are already in this format because there was only 1 time on that day.... and there are lots of blanks.....

Any help is appreciated, thanks again guys.

Answer:Solved: Excel - Text to Row?

6 more replies
Relevance 57.4%

I have two worksheets, Sheet 1 and Sheet 2
The value in Sheet 1 C10 is =Sheet2!(C15)
The value in Sheet 1 C11 is =Sheet2!(C16)

If I have a longer text in C15 and nothing in C16 then the text gets cut off in Sheet 1 C10.
I'm assuming it is because there is a formula in the next cell. Is there any way to show full text when the cell next to it is empty? Changing the width of the cell is not an option.

Thank you.

Answer:Solved: Excel Text is Cut Off

That's the way it works

3 more replies
Relevance 56.99%

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
End Sub
Sub GetData(fl)
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

Answer:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Application.DisplayAlerts = False
WB.... Read more

1 more replies
Relevance 56.58%

Has anyone any idea if it is possible in EXCEL to return , say , the letter "X" , if a range of values has an individual value of ZERO in it , or if ALL the numbers are greater than zero , then to sum the range ?

Alternatively , if a range of values has , say , the letter "x" as one of the entries , to display say , the letter "Y" otherwise perform a summation of the values ?

Answer:Solved: EXCEL : A range with a TEXT in it or

13 more replies
Relevance 56.58%

Hi, We've been having this problem for a while now.

First it started on one spreadsheet, on one users computer. Now it is happening on multiple spreadsheets on multiple users computers.

I am the system admin for this company, and have very little experience with excel, so i just cannot fix this. The users are, doing my head in about getting it fixed, but i dont know where to start.

Hopefully someone here will have the cure to my sore head!


the text in excel seems to resize or change font all by itself. it could happen when it is first opened, or just randomly during data input. Selecting everything and changing the font to Arial 10 *sometimes* fixes the problem for a short period, but recently it *half* fixes it - by restoring half the sheet to the correct font.

I have included 3 screen shots to help you visualise the problem.
2 showing the problem, and one showing the correct view.
The proper screen shot is taken from a different computer, i couldnt rectify it on the one that was having issues.

If you have the answer it would be greatly appreciated.

Answer:Solved: text goes all CRAZY in excel. HELP!

10 more replies
Relevance 56.58%

Is it possible to turn a formula into just plain text that the formula produces? More precisely, I'm doing a huge nasty VLOOKUP on lots of bad data trying to normalize a database. This is involving a lot of sorting, looking up, re-sorting, repeat... so once I figure out the primary key for my database, I want to turn the =VLOOKUP(xxx) formula into just plain text like "2147" that it produces. That way, when I re-sort the source that I'm getting the Primary Key from, it won't destroy my already-found primary key. Does that make sense?

So basically I just need to turn
=VLOOKUP(A1, Range, 3, False) [which produces "2147"]
into regular text
instead of the formula.

Is there any way to do this? I *really* don't want to have to type them all in manually in a separate column.


Answer:Solved: Excel Formula to Text?

Copy the Column with =VLOOKUP(A1, Range, 3, False) [which produces "2147"] in it and then paste it using "Paste Special - Values" in to another column.

2 more replies
Relevance 56.58%

In my database I have select all cells to wrap text but when the text is longer that the column width, the text wraps ok but I have to manually increase each row’s height to be able to see the text.

Is there a setting to have Excel increase the row height as needed to be able to see the contents?

Answer:Solved: EXCEL Wrap Text

14 more replies
Relevance 56.58%

hello i hope you can help with my excel problem. I will start with an example because this will be the easiest way to explain it.

when looking at the example i need a way to look at those 8 columns and output in the blank column the compressor (in this case) that appears. so for example if you look at the 2nd row i need DC57 to be put into the blank column labled "compressor."

There may be some conflicting ones like row 4 and 6. if you look both CBF140 and DC57 appear. For these maybe just output an indicator that there is more than one possible compressor. or even better output all the compressors that show up (if possible)

Is there a formula that can do this because i have 1000's of lines to do.


Answer:Solved: Excel, looking up and outputing text

8 more replies
Relevance 56.58%

I have a cell that needs to run a calculation. The two cells may or may not have a text symbol.

For Example:

The Two cells that need to be calculated may just be two numbers .1 & .3

Other times the two cells may conatin the less than sign. < .1 & <.3

How can I get the calculation to ignore the text symbol?

I know this is probably really simply, but I have not been able to come up with anythng as of yet.

Answer:Solved: Excel Calculation -> With Text


There may be an easier way. Someone will surely pipe in if they have one.

The quotes near the end will cause the cell to remain blank if A1 or B1 have a '<' at the beginning of the text. You can have it do whatever is required to meet your needs.

2 more replies
Relevance 56.58%

How do I get Firefox to remember something typed into a specific field? This text box pops up after I select 'Merchant Accept Liability' from the dropdown menu. I have to type 'We accept liability' into the text box at least 200 times a day. If there was some way for Firefox to remember this, it'd be extremely convenient. Attached screenshot.

Answer:Remembering a text field

One of the best rated form fillers is Roboform. It works in Firefox and IE.


Quality Artificial Intelligence
RoboForm is really smart in filling in forms; it is the most precise form filler on the market. We use Artificial Intelligence techniques to achieve this kind of precision and we test RoboForm thoroughly.

Selective Form Filling
You can ask RoboForm to fill just a part of your form, rather than the complete form. Simply select (highlight) the fields that you want RoboForm to fill and click any form filling button -- only the selected fields will be filled.

You could also try one of these Firefox addons:




Automate Firefox. Record and replay repetitious work. If you love the Firefox web browser, but are tired of repetitive tasks like visiting the same sites every days, filling out forms, and remembering passwords, then iMacros for Firefox is the solution you?ve been dreaming of! Whatever you do with Firefox, iMacros can automate it.

3 more replies
Relevance 56.58%
Question: Text Field Issues

While the main reason for this help request is to help me fix the text field problem Im having, there are a couple other problems as well.

It has become an ongoing problem, no clue what causes it. In certain games, so far only Mabinogi and Test Drive Unlimited, when I go to type something in a text field, my computer pauses, and people talking in Ventrilo repeat themselves over and over for a couple seconds. The same thing happens when I exit a text field in said games. No one else I have talked to has this issue, and I am fairly certain they have slower computers than me, so no clue what the issue is.

The other problem is my graphics card. I have an ATI Radeon x800 card, and when I am playing games, I get errors when it does not even seem to be taking up much memory. I was playing Test Drive Unlimited which I just got today, and I was getting a report error window for ccc.exe about every minute in game. If I ignored it, I could keep going, but eventually another error window popped up saying the same thing, so I shut the game down. I meet the minimum requirements, but I have no clue why its doing this. My computer has a history of overheating, but I don't know if its due to that.

Also, is there a program I can use to monitor the heat in my computer? I'd like to know if that is truly the problem here, as I have been told that my card could be damaged by now if it is overheating.

Answer:Text Field Issues

First heer is a link to the site that has a monitor for CPU and Heat along with a few other things. It is called MBM and about the 11th item down. It is Freeware.I would also suggest getting any Driver updates needed. I do not know what system you have but you can go to the manufacturers site and retrieve them from there. Do these two things and then try the game again so we know if it is a heat problem which it sounds like back and let us knowThank you Jitaa

12 more replies
Relevance 56.58%

when I print to Hewlett-Packard 800 series, instead of printing the page number (or other information) I get...
{page} or whatever the instruction is for the field. In print preview, it shows the number, but then when printed, I get the instruction information.

Answer:field text in Office 97

Please let us know which program next time.

If it's Word (I suspect), go to Tools-Options-Print tab. Remove "field codes".

3 more replies
Relevance 56.17%

I need to create a database with lots of names and addresses plus various fields that I can select to use or not to use when I want to print out labels or create reports based on the fields that are pertinent to each particular project. I see that MS Excel and MS Access BOTH will allow me to create a maintain a database like I need to creat. WHICH ONE should I use to do this project? I have both Acces and Excel on my computer and have never used either one. I do want to upgrade from Office 2000 which I have now to Office 2003 (NOT 2007) if that matters as far as selecting the software program that I should use to do this project. THANKS for pointing me in the right direction and why. Sara

Answer:Acess or Excel, which one to use for my project?

16 more replies
Relevance 56.17%

Hi There

I'm not sure if this is posible or not with Excel version 2000 or any other version for that matter. If not please tell me so.

Below is just an example.

In Cell B2, I have a formula that calculates the mean of numbers that I have in column A. The mean changes as I add more data in colums A. I have created a gragh that plots the data in Column A. I created a text box in the plot area of the chart so that I can type in the mean. For example, Mean = 45.8. Each time the data changes, I have to manually change the Mean in the chart.

In reality, I have a dozen work sheets that calculate the Mean, Median, Standard Deviations, etc. I have to manually change these in the plot area of each chart. Is there a formula or a macro that can do this automatically?? The formula such as ="Mean" & " "&B2 does not work in the text box.


Answer:Solved: Text box inside an Excel Chart

11 more replies
Relevance 56.17%

Dear Tech Support Guys,

I am trying to make Excel search through a bank statement to find cells containing "ORANGE" inside them, and then sum up the values in the corresponding cells in the next column to give the total expenditure for Orange products. However the cells do not just say "ORANGE" but contain unique extra text like "ORANGE (AG/P/01) 01/3199".

I have tried a VLOOKUP function but can't work out how to get it to:

1) Locate any cells containing the text "ORANGE" within the range of data C8: D111 - where C column lists the 'Narrative' (i.e. where the money was spent) and D column lists 'Debit' (i.e. amount spent) - whilst ignoring any extra text like "(AG/P/01) ..."
2) Sum up all the values from the search to give the total expenditure for Orange products.

Hope this is clear enough,


Answer:Solved: Excel - Trying to lookup only cells containing certain text...

7 more replies
Relevance 56.17%


I'm new to spreadsheets and would appreciate any help. I tried using the Macro recorder to do this task but it seems to only work for the cell that I recorded the macro on.

Here's what I'm trying to achieve.

I have text in colum A. I would like to find all instances of "BW" in column A and Copy the "BW" to the corresponding column B

Using the macro recorder only copies it in that one cell.

Thanks for the help.

Answer:Solved: Find and Copy text Excel

9 more replies
Relevance 56.17%

Good day,

I have an inquiry, I wanna ask if there is a way to get the contents of .txt #1 file and place it in a sheet in excel starting from cell A2, then the macro will look for the end of the copied .txt file in excel...offset it by 3 cells down then paste the contents of .txt #2.

Then the macro should also be able to delete the pasted values from .txt #2 and replace it with .txt #3 at any time should the user choose to do so still making sure that it's below .txt #1.

The data is actually being used by a pivot table, it would just refresh everytime we have a new .txt file coming in without replacing the first part. Oh...i don't have Access on my system, I only have VBA in Excel and the text files to use.

Answer:Solved: Text files and Excel Macro

6 more replies
Relevance 56.17%

Hi I am trying to create a macro in excel that will perform a number of formatting tasks in preparation for the csv file to be imported into another database. I can't seem to get the macro to delete all of the rows containing text (specifically "student(number)") instead of numbers. It seems to work for some but in my test file I always have 4 rows remaining. It also doesn't seem to work on the first row of the worksheet. In the code below I am referring to the section that is commented with 'Find text in column A and delete row. Any assistance would be greatly appreciated.

Sub LMSImport()
' LMS Import Macro
' Prepare csv file for import to LMS

Dim wscell As Range
Dim lastrow As Long
Dim username As Range

'select last 2 columns and delete
Selection.delete Shift:=xlToLeft

'Find text in column A and delete row
For Each username In Range("A:A")

If username.Value = Empty Then
Exit For
End If

If username.Value Like "*student*" Then
Selection.delete Shift:=xlUp
End If

' Insert e-learning into column G
lastrow = Range("G1").End(xlDown).Row
ActiveCell.FormulaR1C1 = "e-Learning"
Selection.autofill Destination:=Range("G1:G" & lastrow&)

' select column D clear and convert column C to uppercase
lastrow = Range(... Read more

Answer:Solved: Excel vb code delete row containing text in A:A

It seems to work for some but in my test file I always have 4 rows remaining. It also doesn't seem to work on the first row of the worksheet.
Click to expand...

The code you've marked in bold will delete the top row (1:1) on condition stated is true; You've not stated why you're doing this, and I'm not sure this is what you intend.

I'm second guessing that you want to delete the rows which meet your condition rather than the top row, in which case replace the your bolded code with:

'Don't for get to dimension the variable 'x' at start of your code

For x = Cells(Application.Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Cells(x, "A") Like "*student*" Then
End If


3 more replies
Relevance 56.17%

Ok I have tried to figure this one out myself and to no avail.

What I am trying to do is create a macro that would add text at the end of the text in a current cell.


Company 1
Company 2
Company 3

I am trying to create a macro that would would go thru each cell and add "Total" to the end.

Company 1 Total
Company 2 Total
Company 3 Total

Every time I try and create a macro, it copies the previous text into the current cell.

Thanx in advance.

Answer:Solved: Excel Macro Help - Adding Text

15 more replies
Relevance 56.17%

Hey guys

Its been a long time since I have used Excel for fancy stuff. Is there a way to merge 2 cells in one with just text? For example A1 has the word Tech, A2 has the word Support, and A3 would be the cell with the merge, so the value will be TechSupport?

Answer:Solved: MS Excel - Merging two text cells

7 more replies
Relevance 56.17%

Is there a way, without using a macro, to set the Format function 'Wrap text' to default to off? Really tired of having to do this format every time I paste into excel. I'm thinking regedit?

Answer:Solved: Excel Wrap text-Set default

You'd expect it to be somewhere under Options (advanced)
I don't have that problem, but could it be that what you are pasting contains CR or similar codes?

Try it pasting one of those stings in Notepad to check.

2 more replies
Relevance 56.17%

I want to add text to the end of the output of a formula in Excel 2010, but can't find the right sintax. I've done this before in Excel 2003, I'm sure the text needs to be double quotes but how to add it to the formula???

e.g. the basic formula could be =sum(A1,A4) where A1=12 and A4=13 and I want it to display 25 apples

Answer:Solved: Excel - adding text in formula

6 more replies
Relevance 55.76%

Ok, first, I'm running Windows XP Pro SP2 on an HP Pavilion 8760c. It originally came with Windows 98, but the previous owner upgraded it to the XP sometime before giving the computer to me. I do NOT have any disks, neither the original system disks nor any restore disks, nor does there seem to be any restore partition on the hard drive.

First problem is -- for some reason when I try to type into any text fields in any windows based programs, the cursor goes into hyperblink mode, won't click into any text field, and won't let me type in any of them. I first noticed the problem when I tried to use internet explorer, I went to Google like normal and while it will let me type in the address bar at the top, it won't type into the Google search field. I have since found out it is NOT IE specific, but it won't let me type into the windows help search field, or the field where you enter a name for a restore point when manually setting it, or in the captcha box on a game program I use or pretty much anything windows based. I downloaded Firefox and I can type in Firefox with no problems, which is fine for searching the web, but does not fix the problem.

Second, with the system restore... this computer used to work fine. I used it occasionally at my old house, then we moved and the computer sat idle for about nine months, and I just hooked it back up last week. When I did I found problems with the sound as well as the problem with the text fields I mentione... Read more

More replies
Relevance 55.76%

From a specific text value in one field I need to count that field in multiple other fields. ie: in one column, for each text field marked Trip1, I need to add to a count in a Compartment1 field, a Compartment2 field, and a Compartment3 field.

Answer:How to count text values in another field

Perhaps we could be of some help if we knew what application you are talking about. Even if we know the application, I'm not sure there is enough information in your post for us to answer.Perhaps you could add a few details regarding what it is you are trying to count. Keep in mind that we can't see your computer from where we are sitting, so the more details you provide, the better.Thanks!Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 55.76%

Where is the setting to change the color of text fields? The color options in the options menues just change or force colors on the webpages themselves. Im looking to just change the color of the address/google bar, and any text fields that happen to appear on a webpage. Right now they are all a dark ugly grey, where if I open the same page in IE everything is properly colored to the pages defaults or to my light colored xp theme.

More replies
Relevance 55.76%

Recently there's been an annoying little animation pop up whenever I click something. I can't really explain it, but it's similar to the blinking | you see when typing in text fields. Everything I click on something it shows up. It's really annoying. It even happens when I click a picture, except it appears as a HUGE blinking bar. Can someone help?

Answer:Not sure.. text field-like highlights when I click anything

A sometime worth a thousand words, can you post a screenshot?


7 more replies
Relevance 55.76%

when i open yahoo mail ,nd go for composing , the text area does not appear nd so i could not able to wright mails to my friends.the page displays also done with error. pls help me out of this problem

More replies
Relevance 55.76%

I am currently building myself a stock database system in MS Access 2000. On one of my forms and reports. I want my text in a textbox element to flow vertically. I have found a method to do this, but the text runs the wrong way. Would it be possible for my to correct this in anyway? If so how would I do it?

Answer:MS Access text field orientation

Help! Anyone? Please.

2 more replies
Relevance 55.76%

Hello All.
Public Sub AutoExec()
MsgBox ("The Word Startup Folder is: " _
& vbCrLf & Word.Application.StartupPath)
End Sub
First, I want to again thank everyone who helped me with my first question: Text Form Field in Word 2003.

My next question is: Is there a way to automatically tab to the next form field?

End Time
I would like to key in the hour (00), skip over the colon, key in the minutes (01) and have Word or VBA tab to the next field.

Can this be done? Any ideas?

More replies
Relevance 55.76%

When creating, forwarding, or replying an email; the text field does not open automatically. It must be expanded manually. What is my problem? Thank you.

Answer:Outlook Express Text field

Have you tried this.

make Windows Mail or Outlook Express open email messages to windows that make use of all the available screen space automatically:

Open any email in its own window by double-clicking it in its folder.
Make sure the window is not maximized.
Move the window so that its top left corner coincides with the top left corner of your screen.
Grab the handle in the window's bottom right corner with the mouse and drag it to the bottom right corner of the screen.
Close the message window

1 more replies
Relevance 55.76%

I have a table consisting of 8 columns by 26 rows. In each cell, I'm adding a Text Form Field. Is there anyway, besides doing it cell by cell, where I can just copy a row, then paste the same Text Form Field with text length maximums in the other 25 rows?

Answer:Word - Text Form Field

Sure, Brian.
Create first row.
In Print Layout view, take your mouse pointer to the left of the left-most cell in the row, and it should turn into a 1:00 pointing arrow. Click to select the whole row, then Ctrl+C to copy. Place your cursor in front of the paragraph return just below the table OR in the left-most cell of the row that you want a new row above, and hit Paste.

3 more replies
Relevance 55.35%

Hi everybody,
i have the following problem. I need to color the largest 10 and the smallest 10 cells in a row and insert in each of them the letter "W" for the largest and "L" for the smallest ones. The letter can appear both at the beginning or at the end of the cell. Furthermore, i have a long list of rows (1124) and i need to do this for every 11th row starting from row 4.
I've attached an example file to make it clearer.There you can also see the macro i'm now using to color the largest/smallest cells in the corresponding row.
What i basically want is to make the letter "W" ("L") appear in the red (yellow) cells before or after the number in the cell and to make the macro do this coloring&inserting letters for every 11th row starting from row4.
Thanks in advance.

Answer:Solved: Excel: insert text in colored cells

10 more replies
Relevance 55.35%


I currently have a worksheet called "Plan" where the user will enter text into "C34", once complete they will click on a form control button to email the spreadsheet.

I need help with code that would "copy" the text from "C34" to a worksheet named "Goal 1", position "C8" when the user clicks the form control button.

Any help would be greatly appreciated.

Answer:Solved: Excel Copy text code help needed :-)

Decided to use a formula instead ;-)


1 more replies
Relevance 55.35%

I have used your website many times and to date have found answers to my questions without having to post one.

I will try to make this clear as mud.

I have created a spreadsheet that has only text. On the first sheet is a list of employees, the following sheets are timecards for each construction crew. The formula ='2950'!C48 gave the correct information: Robert . It worked great until I moved employees around. Then then formula changed to reflect where I moved Robert, rather than remaining with the C48 (which is what I want).

I tried using this: =INDIRECT('2950'!C48) but it does not work, as I get #REF! .

How can I have the formula always reference C48 and not change when I move employees around on Sheet 2950?


Answer:Solved: Excel 2003 INDIRECT to text on another worksheet

try inverted commas around the reference

3 more replies
Relevance 55.35%

I opened 2 of my excel 2003 spreadsheets and found
(a) the row heights were compressed
(b) none of the text in the cells was visible - although I could still see it in the Formula Bar

Has anyone seen this glitch? Can I fix it?
Thanks -

Answer:Solved: Excel 2003 text invisible in cells

7 more replies
Relevance 55.35%

Some background:
We get a schedule from a client that comes in an XLSX file format. The workbook has dozens of worksheets and currently I have a vbscript that saves only the worksheets I need as tab delimited files. We use the tab delimited files as input to a SAS program.

Now one of my users has requested if we can remove any text that has the StrikeThrough effect from the excel file before it is saved as the tab delimited file.

Now I found a Macro where I can select a range of Cells and run the macro to remove any text with a StrikeThrough effect.

Now my issue is how can I automate this from within my vbscript. We receive an updated schedule weekly and currently we have this whole process completely automated. Client drops the file into a folder on our ftp site and we have a process that watches that folder and pulls down the XLSX file and kicks off my vbscript to run it. It outputs the needed worksheets to another folder and another process watches that and kicks off the SAS program.

One thing I noticed with the Macro is if I select a range of cells with it and one of those cells is just a number I get an error and the macro stops running.

Here is the vbscript I am using. If anyone can look at the Macro and figure out how I can integrate it into this whole process I would appreciate it. And if you see anyway I can improve this Vbscript let me know. I am still pretty new to VBscripting.

Set objArgs = WScript.Arguments
For I = 0 to objArgs.Count - 1
Set FSO = ... Read more

Answer:Solved: Deleting Strikethrough text from an Excel file

16 more replies
Relevance 55.35%

I have a large workbook (over 4 meg) with multiple sheets and lots of formulas. Today, I was trying to change a cell formula and instead of placing the result in the cell, the formula was placed in the cell and displayed as text, complete with the '=' sign in pos 1. The Evaluation tool states that the cell contains a constant.

The following is an example. The original formula and the mod with the changed component in red.

Original cell formula: =SUM(INDIRECT("T$"&MATCH($V1265,$V$2:$V1265,0)&":T"&ROW())). The cell result is a number.

modified cell formula: =SUM(INDIRECT("T$"&MATCH($V1265,$V$1:$V1265,0)&":T"&ROW())) . The cell displays the formula, exactly as shown, as text and therefore no result.

Has anyone ever encountered this before and is there a solution?
Thanks, Tom

Answer:Solved: Excel 2003: Formula Cell Becomes Text After Mod.

7 more replies
Relevance 55.35%

I have the following data:

Each of the cells is formatted as a date, and is a value.
What I would like to do (and what could be done under Lotus) is to record a macro that puts the ' in front of 1/1/05 and makes it a value. I realize there are other ways to do this, but the functionality of adding a character before a value is what I am looking for.

Functionally, I record this macro with these keystrokes:

F2 Home ' Enter

which results in this code:

ActiveCell.FormulaR1C1 = "'1/1/2005"

If I run this macro, it changes the cells underneath to 1/1/05, instead of keeping their date. Where am I going wrong here and how can I make this work?


Answer:Solved: Excel and VB: Changing cell value to text with macro

16 more replies
Relevance 55.35%

Hi all,

I am currently using Excel 2003.
I have a column of dates which display the following format 17-Feb-2006. I would like to copy theses from one cell to another, but not in a date format, but as text. Problem is, if I copy into another cell and change the cell format to text, it diplays the cell valuation of 38765.
I also try the data>table to columns route and it does show the cell as text but in this format: '02/17/06'

I believe in excel 97 I could simply copy>paste special>text only, but this seems to have been removed from excel 2003.

I have also simply tried to insert an apostrophe at the beginning of the data in the cell, but this also goes on to display the following format; '02/17/06'

Does this make sense and if so, can anyone pleeeease help.

Many thanks

Answer:Solved: Excel 2003 - Copying dates as text

7 more replies
Relevance 55.35%

I have two sets of texts in an Excel 2007 worksheet.
One set is to guide how to fill in the data and does not need to be printed out. I have coloured this text red. The set of text i need to print is coloured red.

I need to create a conditional format that will hide the red text so that it does not print out on paper. I need the text to be visible when editing.

Answer:Solved: HIDE/ not print RED TEXT IN EXCEL 2007

12 more replies
Relevance 55.35%

I want a name list in Excel and want to add all the names to a total.

can I have the formula to total each cell to the value of 1 when there is text in the cell?


Answer:Solved: (Excel)Can I use text in a cell and make it equal to 1

Try a formula like the one below which will count all the non-blank cells in the range A1 through A100



2 more replies
Relevance 55.35%

Hi im having a problem trying to merge two cells together containing text collectivly over 255 charectors and its showing #Value

How do I over come this. Formulae looks something like this =A1+A2+A3

But th combined texted is over 255 charectors

Answer:Solved: How do I merge html text cells in excel

Hi chessmaster, welcome to TSG.

You cannot add cells to combine text. It's showing #VALUE because Excel doesn't know what you mean by adding. Instead, try using =concatenate(a1,a2,a3). Let us know if that helps.

3 more replies
Relevance 55.35%

Is this possible? If so, how? I have created a "combo box" (from the forms toolbar) in a MS Excel 2000 (9.0) spreadsheet and, using the format control option, set up the list from which a choice has to be made. I'd now like to change the font size/colour etc of the items that appear in the pull down field, but can't find the way to do this?

I suspect that I've done the hard bit and am missing something obvious...

Answer:Solved: Formatting text in pull down lists within Excel??

9 more replies
Relevance 55.35%

Our department receives an Excel spreadsheet with a multitude of sheets on a regular basis from another department. Some of the cells are formatted as "General" and others as "Text". One of our departments macros searches for certain instances of a number on the Logic and Flow columns such as the number "1". In doing so, the macro finds "1", "21", "102" and so on. Or if seaching for the number "20", it finds "20", "120", "201" and so forth. I would like to run a macro on each sheet that would, if need be, change all of the data in the Logic and Flow columns to Text and then add leading zeros to make each of the numbers in the cells 3 digits long. In my example, Cell B2 original has a 4 and a 2 (4 2). I want to end up with 004 and 002 (004 002). In my example, Cell B8 original has a 20AT. I want to end up with 020AT.

In my attached example, Columns B & C are what we get from the other department. I want to end up with what is shown in columns F & G.

Answer:Solved: Add zeros to excel cell formatted as text

16 more replies
Relevance 55.35%

I have an excel file with the current scenario:

A12 - this cell uses a CONCATENATE formula (from other cells) to create a directory structure and file name (example- C:\project\vendor\41576_info.txt). The directory structure already exists. The the *.txt file does not exist.

I would like to use a VB macro that will create the new text file in the specific directory and add any content in cells A13:A17 to the text file. Any suggestions on how to do this? Thanks in advance

PS - I did try to look through previous posts but the search function was retuning errors.

Answer:Solved: Saving Excel Data to a text file

6 more replies
Relevance 55.35%

I'm not sure what is the right term for textbox.text to workbooks.fileopen
or maybe there is a better way.
my file names are month-day-year.
maybe a pulldown menu would be better.

Answer:Solved: Open excel file with text from textbox

I got this Taken Care of thanks


1 more replies
Relevance 55.35%


I am trying to find a way to get Excel 2003 to allow a large amount of text be placed into one cell without restricting the vertical size of the cell. I am importing several fields, one of which is a comments section that often has up to 500 words. However, when it dumps into Excel, the default is for the cells to be expanded horizontally, not vertically, and I'm limited on how tall I can make the text cells until it no longer accommodates me and just keeps the text at a fixed height, while the width is ridiculously long.

Is this something that I can manipulate somehow? It seems to do this no matter if cells are merged or not, but the way.

Thanks in advance for the help.

Answer:Solved: Limited Excel cell capacity for text

11 more replies
Relevance 55.35%

I am using VLOOKUP in a very old version of Excel (2000) to extract some data, nothing unusual in that except the data I wish to extract is of the following general format in each cell:

text A
text B
text D

It is important to keep the formatting, in particular the bold text, however VLOOKUP does not seem to preserve the bold formatting.

All help gratefully received. Thanks.

Answer:Solved: Excel - VLOOKUP keeping text formats

8 more replies
Relevance 55.35%

Hello All.

I am attempting to create Text Form Fields in a previously created Word document. It was not created from a form template.

The field is the DAY in the date field: 10//007. I put the insertion point in the DAY field, click on the Text Form Field icon and fill in the field attributes. Type=Number, Max length=2. I type in a Help description, click OK, save the file, and click on the Protect icon.

When I key in a 2-digit num and press tab, the next page comes up. The same thing happens if I try to put in alpha characters. My help message does not appear. I pressed F1.

I would appreciate any help with this issue.

Answer:MS Word 2003 Text Form Field

9 more replies