Free Microsoft Excel 2013 Quick Reference

How to remove a constant from a column

I have a long Excel column that has a constant in every cell. Does anyone know a way on how to remove it.
Example: I have in the column
06/14/1978 12:00pm
04/12/1960 12:00pm
09/34/1980 12:00pm
How can I get rid of the 12:00pm that appears on every cell but keeping the rest of the data

Blessings and thank you


Post your answer or comment

comments powered by Disqus
Dear Friends,

How to remove the Underline from a Text which is linked to another slide in MS Powerpoint 2007?

Please do help.

how to remove selected item from combobox itself?
i hv a bottom. once the click, the selected item will go to list box but the problem is i can't remove tat item from my list box!

Help me, many thanks!

I see a post that explains the use of ~ before unusual characters to find and replace but unfortunately I havent figured out how to remove tab characters from columns.

I need to remove any stray tabs from my data as it screws up the import of tab delimited files from my database.

thanks.

I have a requirement to develop a VB6 application, when I click a button the
application should automatically generate a Line Graph, Column Chart and a
Map on separate tabs of an Excel workbook using an existing cross-tab report
data (Report tab) from an Excel worksheet. I have installed MapPoint software
on my machine and I could see a MapPoint icon like Chart wizard in insert
menu.

Using Macro record feature and Chart Wizard I was able to develop an
automized code for creating Charts…Using MapPoint feature inherent to Excel
I was able to create a Map manually but I was not able to record any thing in
the Macro the moment I click on MapPoint Icon the macro recording stops. Can
any one help me in finding how to generate a Map from Excel cross tab report
using MapPoint Software? I appreciate all your help…thanks much in advance…

--
Have bugs free to have peace of mind!

how to read a value from a cell in VBA?

How to pass a parameter from a sharepoint list via a query string to an infopath form

How to pass a parameter from a sharepoint list via a query string to an infopath form?ram

Hi,

does anyone know how to stop a user from creating a circular reference using VBA code. For example if the user tries to create one a msg pops up saying that the user is not allowed to create circular references

thanks

Hello,

Does anyone know how to remove a space after a string?

does excel read 'space' a string?

ie:

1.holiday inn(no space)
2.holiday inn(space)
3.holiday inn heathrow(space)

is it possible to keep the space been holiday and inn, but remove the
space at the end?
keeping the space between holiday and inn, inn and heathrow but remove
the last space?

and do nothing if theres nospace at the end of 1st holiday inn?

thanks.

Elaine.

Hello,

can anybody tell me how to use a macro from another excel sheet.
Situation :

I have 1 file called records.xls
This file has to be overwritten every time when filled (export from access).
When this opens I have to start an Excel macro.
How can I use or start a macro which is in my other file : macro.xls (empty
sheet with just a macro in it).
Or any other solution is welcome.

Jeroen

Hello all,

I have tried to google search but I got only links explaining how to
remove a reference from a VBA project.

At the moment I am developping a C# addin, however each time I
reference it, it creates a new entry in the references list. Is it
programmatically possible in VBA or C# to check all the reference and
remove the bogus ones from the list itself ?

Cheers
Anthony

Hi everyone
I'm trying to figure out how to activate a macro from combo box or list box.
But no success.

I have a list of names:
AAA
BBB
CCC
111
222
333

That I can view through the combo box.

I have created a list of macros, that carry the same names,

AAA
BBB
CCC
111
222
333

The Q is: how can I link each name to its own macro?
so when chosen, will activate the macro?

Thanks for the help

Can someone please tell me how to remove a filename from a file path?

Basically, turning

c:wordlegalgovtstatestate laws.doc

into

c:wordlegalgovtstate

Hi, i have a question about drawing chart.

a table has 3 columns, year, x-value and y-value
year X-V Y-V
------------------------------------------
1995 5 7
1996 10 22
1997 7 3
...............

I need to draw a chart from this table, each point should determined by x and y value, meanwhile, its year should be labled next to the point, how can i do this, i have no idea how to show year value to each point.

Cheers

Well, I got something that did work. I changed

Set ref = Application.VBE.ActiveVBProject.References
to
Set ref = Application.VBE.VBProjects("MyProj").References

Where I renamed the default project name of VBAProject to
MyProj.

Now I can see my dll class, and I was able to remove it.
Whatever works, heh? I am still open for suggestions if
anyone has a better (or more correct) way to do this.

A J

>-----Original Message-----
>Hi All,
>
>I have an Excel project where I make a reference to an
>ActiveX dll class I wrote in VB6 on my workstation, but
>that file is not installed on other workstations which
>will use this Excel file. So I need to programmatically
>remove the reference before shipping the Excel file off.
>The purpose of the dll class is to collect data from an
MS
>Access Application and pass it to this Excel file. This
>works fine. But I need to remove the reference to my dll
>class in the Excle File. Even though the dll class
passes
>the data correctly to the Excel file, I can't detect it
>with the following loop, and thus cannot remove it.
>
>Dim v As Variant
>For Each V in Application.VBE.ActiveVBProject.References
>Debug.print v.Description
>Next
>
>This will correctly print out all the standard references
>and even the reference to VBA Extensibility, but it won't
>detect my ActiveX dll. In Access I can remove the
>reference successfully as follows:
>
>Dim ref As Reference
>Set ref = References!MyRef
>References.Remove MyRef
>
>But this does not work in Excel. If anyone knows how I
>can do this in Excel, I would be grateful if you could
>share.
>
>Thansk,
>A J
>
>.
>

I am at a cabinet building company and we are needing to incorporate an
on-going column of accumulative totals, and they stay constant even when
other formulas that change the totals are changed or the other values
pointing to the totals are changed. I guess you could call it a column of
constant totals.

This is so that we can always see the accumulative total of cabinet parts
and we use other worksheets to change the totals to what they are and we'll
have other output sheets showing cabinet parts needed for a set of cabinets.
And when 1 job is done, we want to delete those entries and start another
job, but the totals stay constant from the last job session.

Help,
Jim

hi i want to extract a value from a column into another column in excel.
this first column contains text and i want to extract a value that in located between the characters 'FOR' and 'MTHS'.
how do i do that?
the situation is the same for all the rows; the value that i want is just located between these characters.
is there a simpler way other than using the MID functn? because everytime i use it i need to count the no. of characters and its quite difficult to keep up with the numbers.

I have data in cells A2 through A6.

How do I auto-populate that same data in cells B1 through F1 from the data that is in A2 through A6?

Essentially, I want to populate a ROW from a COLUMN without having to retype every cell.

Thanks

Brett

We have a merge file set up in Word 2000 that merges with an Excel file which
imports its data from a text file and gets "refreshed" with each use.

These files are used by a number of individuals, but one of the users
recently upgraded to Office 2003 and is now getting a prompt whenever he uses
the merge file(s) stating there is an "SLQ query attached to this
file....should it be activated.." and "Do you want to refresh data?"

My coworker does NOT want to have to answer these (and other) prompts when
entering a file, but I can't figure out how to remove them.

Can someone tell me where this option is located so it can be "turned off"?

Thanks!

Hello, i have two columns of words, lets say col A with 10 words one under another and col B with 10 words one under another, I want to append* each word/row from col A to each word/row from column B resulting 100 words/columns.

COL A COL B
car | red
truck | blue
boat | white resulting:

car red
car blue
car white

truck red
truck blue
truck white

boat red
boat blue
boat white Anyone knows the forumla for this? I hope I explained correctly.
Thank you.

I am using Excel 2003 Visual Basic Programming to try to improve my work . I
have an excel sheet with two coloumns, one coloumn contains nanes of
companies, named first coloumn, and the other, the secomd colomun containes a
modified list of the companies with new companies added randmoly in the
second coloumn . I used the the VLOOKUP function to compare between two
lists of companies names in different coloumns and find out the new company
name which appears in the second coloumn an not exist in the first , then I
wrot a VB code to put the new company names under the names in the first
coloumn.So, the first coloumn shall contain the new company names at the end
of the coloumn besides old company names that it already exist.
The problem is that the new names which appears in the first coloumn due to
to VB code are in scattered rows, i.e, the first coloumn now has many blank
rows(or cells) seperating the new company names generateg by VB code.
My Question is How to remove blank rows (or cells) that appears in the
first coloumn?
using suitable VB code?

We have a merge file set up in Word 2000 that merges with an Excel file which
imports its data from a text file and gets "refreshed" with each use.

These files are used by a number of individuals, but one of the users
recently upgraded to Office 2003 and is now getting a prompt whenever he uses
the merge file(s) stating there is an "SLQ query attached to this
file....should it be activated.." and "Do you want to refresh data?"

My coworker does NOT want to have to answer these (and other) prompts when
entering a file, but I can't figure out how to remove them.

Can someone tell me where this option is located so it can be "turned off"?

Thanks!

hello

I'm currently using this macro for converting a column that has mixed
types (text and numeric) and change it to being text.

Sub AddSpace()

Dim r As Range
Dim Wks As Worksheet
Dim cell As Object
Dim found As Boolean

For IndexSheet = 1 To Sheets.Count
Set Wks = Sheets(IndexSheet)
With Wks
.Activate

'find the column that has to be changed
found = False
For Each r In .Range("1:1")
If r.Value2 = "Values" Or r.Value2 = "Value" Then
r.Activate
found = True
Exit For
End If
Next
If found = True Then

Range(Selection, Selection.End(xlDown)).Select 'this is the
'column to change

Selection.NumberFormat = "@" 'not there yet, we have to
'add and remove a space
'from each cell to achieve desired result

For Each cell In Selection 'this is the slow part,
'this is too slow for 39800 rows
cell.Value = " " & cell.Value
cell.Value = Right(cell.Value, Len(cell.Value) - 1)
Next
End If
End With

Next
ActiveWorkbook.Save
End Sub
------------------------------------------------------------

is there a way to convert the entire range at once?

Hello everybody:

I am urgently looking for the answer to the following question. How to
increase a spreadsheet's totalcolumn number from 256 to a larger one(346, for
example)?

I would be very appreciated if anybody can give me some hints

Thank you very much

Is there a way, using VBA code, to remove a hyperlink from a cell, while
retaining the cell text content?

Thanks,

Keith


No luck finding an answer? You could always try Google.