Putting A Space

Nov 12, 2008

how do I put a space?

12345 ** =A1&B2 gives me 12345CD

but I want 12345 **

View 2 Replies


ADVERTISEMENT

Custom Text Format - Putting Space Characters Before And After The Period?

Oct 4, 2012

using this format *.#,##0_);*.(#,##0);*.0_);@*. I get this:

Bonds..................................

would like custom format to do this,

Bonds . . . . . . . .

note:@ sign activates text formatting, *=repeats .=character being repeated

I've tried putting space characters before and after the period - no luck

View 2 Replies View Related

Extend Space Of Userform Beyond Its Maximum Space?

Oct 16, 2012

Is there a way to extend the space of my userform beyond its maximum space? I have tried using vertical scroll bars but they were of no use.

View 1 Replies View Related

Locate Text String After First Space And Before Last Space

May 26, 2007

I have been working on different formulas to return the text string between the first and last space and have been unsuccessful. Is this possible?

I have tried several combos or Left and Right, I have been able to get the values after the first space, and the values before the last space, but not between the spaces.

String: Y60
~C CULT NUCLEUS 3X2 SPRING WST BK XL

Desired results: D60
CULT NUCLEUS 3X2 SPRING WST BK

View 9 Replies View Related

Remove All Text Left Of Space And The Space

Feb 10, 2007

I have two words of differing character lengths separated by a space.

How can I remove the first word... essentially, all the charcters to the left of the space AND the space itself?

View 9 Replies View Related

COUNTA Not To Counting Space Bar Space

Feb 15, 2009

I have the following formula that works fine until someone uses the space bar to clear a cells contents

=COUNTA($D11:$AI11)

When the space bar is used to clear a cells contents the COUNTA statements includes the space in the count. How do I count the number of cells with content and exclude the space bar space in a cell?

View 4 Replies View Related

Delete Space After Dot In Cell B1 If A1 Contain Dot Without Space

Nov 6, 2012

If find dot. with out space in ( A1 ) cell remove space after dot in cell ( B1 ) Cell, vb or macro

A
B

M V Micunovic
MICUNOVIC,M V

L.T.Kudrjavceva
KUDRJAVCEVA,L. T.

D Sumarac m.l.
M. L,D SUMARAC

View 1 Replies View Related

Remove Only One Space If There Is Space From The End Of Text

Apr 10, 2013

I only want to remove one space at the end of my text within a cell, if there is a space.

Code:
Sub hth()
Dim c As Range

For Each c In Range("H1", Range("H" & Rows.Count).End(xlUp))
c.Value = Trim(c.Value)
Next c
End Sub

View 9 Replies View Related

Putting Two Cells Together With 0

Mar 26, 2014

I have a cell in A1=(str identification is = ",) and in B1=(2). In C1 I want it to equal (str identification is = ",02) In C1 I have A1&B1

View 4 Replies View Related

Putting Another Code In The Same Sub

Jul 1, 2008

putting another code in the same sub.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Set rng = Range("O2:O501")

If Intersect(Target, rng) Is Nothing Then Exit Sub

If Target.Value "X" Then
With Target
.Value = "X"
With .Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 14
.ColorIndex = 3
End With

Plus this one

Set rng = Range("P2:P501")

If Intersect(Target, rng) Is Nothing Then Exit Sub

If Target.Value "X" Then
With Target
.Value = "X"
With .Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 14
.ColorIndex = 5
End With

View 9 Replies View Related

Putting Together The Data From 2 Sheets?

Apr 1, 2014

There are two sheets with data:

Sheet 1
Column A - reservation number (unique)
Column B - trade partner

Sheet 2
Column A - reservation number (unique)
Column B - Hotel property

I want to put in one sheet: Reservation number - trade partner - hotel property

In another words I want to have a list of all reservations according to hotels and partners.

View 2 Replies View Related

Putting A Calculation Into Text

Feb 24, 2009

I want to be able to automatically put the calculation of one cell, into the text of another cell.

so....

Cell A3 = A2-A1

And in another cell say B3, i want to be able to write text that says "The value of cell A3 is 'A3' "

View 10 Replies View Related

Putting The Header Row Into A String?

Jun 5, 2014

I want to know that are there anyway I can quickly declare the header row of the sheet into a string instead go through each one of them using dim xxxxx AS String?

View 3 Replies View Related

Putting Names In Combobox

Feb 14, 2014

Attached is a small sample, how to put the text from A1 to combobox1, the text from A2 to combobox2 and so on

Up to combobox6, when the form loads. but be able to change the text A1 thru A6, and no matter what text I put in A1 thru A6 the form loads with whatever text is there, is that possible?

View 2 Replies View Related

Putting Formula In Cell With VBA

Oct 23, 2008

I tried to put the following formula into a cell using vba, but I received alot of errors. here is the formula I am trying to put into a certain cell and I will use a variable to replace the row number in the formula

=IF(AD323<>"Open","",IF(OR(AND($AI323=TODAY(),$AJ323<>"Done"),AND($AN323=TODAY(),$AO323<>"Done"),AND ($AS323=TODAY(),$AT323<>"Done")),"Yes",""))

View 5 Replies View Related

Putting Spinbuttons In A Worksheet

Nov 14, 2008

The code below places a spinbutton on the worksheet. The linked cell = F10 This works ok. The orientation is vertical and max is 100
However I would like to set the orientation to horizontal and the max value to 1500. Which commands must be added for this in the macro below? I work with Excel2000.

View 4 Replies View Related

Putting A Table Into A Userform

Feb 18, 2010

I have 2 columns of data in an excel sheet and I wish to add this to a userform so that the userform displays the 2 columns beside each other with headings, like a table. The user should then be able to select a particular row and insert it into the specified cell.

I would also like the user to select a row on the table and then be able to bring up another table depending on the row selected...basically so that the user can draw deeper into the information that they require.

View 5 Replies View Related

Putting Variables In Array

May 7, 2012

I want to know if I can populate an array with variables..

For example, imagine I've declared 3 variables a, b, c.. and each variable has been assigned a value (which can change)

now I want to say this:

myArray = (a, b, c)

then I want to be able to loop through myArray and retrieve the value attached to each variable..

View 6 Replies View Related

Putting Date In UserForm

Nov 26, 2012

Is there any way for me to put a date in the userform? I created 3 combo boxes (day, month year). I would want it to appear as one date in one single cell in the another sheet as the date the entry was updated in the userform.

View 3 Replies View Related

Putting Input Into A Macro

Apr 24, 2007

I would like to write a macro that would start by asking me something along the lines of, "Enter student # you want to print a report about." The # I enter would need to be stored as a variable in the VB code, and then my code would need to use the variable to do some search and replace operations. (Replace all instances of 10 (the default student number) with the variable I have specified).

I don't really know how to even start going about this. How do I get Excel to ask me for a variable, and then use that variable in code?

View 9 Replies View Related

Putting 2 Conditions In IF Statment

Jul 16, 2008

I would like to check whether 2 conditions are satisfy in an if statement. One condition is of data type text and it is stored in a variable calls search1 whereas the other condition is of data type date and i intend to store into a variable calls search2. Could someone tell how to put search 2 into the below code. Basically, i want it to be like

if Cell A is equal to search1 and CellB is equal to search2 then

return value that is associated with the search in cell c


ActiveSheet.Cells(r, 13).FormulaArray = "=MIN(IF(Sheet1!$A$1:$A$20=""" & search1& """,Sheet1!$C$1:$C$20))"

View 9 Replies View Related

Empty Cell Without Me Putting A Zero

Nov 17, 2008

How can I stop #DIV/0! in a cell which has a formula relating to a cell which will have a number inputted but at the moment is empty, without me putting a '0' in?

View 9 Replies View Related

Putting Formula Into A Cell In Another Workbook

Jun 13, 2013

When I try to run the macro, an error comes up saying application-defined or object-defined error. The following code is the line in which I receive the error.

VB : tool.Worksheets("ALL").Cells(row1, "J").Formula = "='[TRB Database.xlsm]TRB Database'!$I$" & A

View 3 Replies View Related

Putting Lines Of Data Into A Table

Dec 23, 2013

I am having trouble being able to put data into a table. The data I have breaks down orders of products in crates into lots of 45 crates with a remainder.

I would like to be able to fill a table from left to right which displays the item number with the corresponding amount of crates, which seamlessly goes from one item to the next.

I have attached an example.

pallet data.xlsx‎

View 5 Replies View Related

Taking Entries From Certain Columns And Putting Them Together

Apr 4, 2014

I have a huge spreadsheet where after every 12 columns there are two "special" ones, which contain certain entries. In the first of these two, the entries from the second one are numbered in a certain way. Please see the example.

I need a formula in a separate column (yellow) which will gather all these entries from all columns, and put them in order, as I did manually in this example.

Instead of 4 "groups" of columns, in my real file I have 200 of them, with 400 rows each, which makes it more complicated..

View 2 Replies View Related

Putting Text In A Referenced Cell

Jul 10, 2008

In my excel sheet I have a list of where they go, which are basically excel cells.. i.e. A1 is the top left corner.

What I am trying to figure out how to do is, is there a way that I can get excel to see "A1" and then put it in A1 of another sheet on the bottom. Thus I get the same grid I have on the wall, making a map of my things.

Also, I could just cut and paste, but the problem is I'm working on organizing the stuff on the wall, and if I do it the way I want to, when I move things, they should automatically be moved on the chart.

So basically I need it to look at a cell for the reference, choose text from another cell (which will be concaternated(sp) text), and then place it in the referenced cell in the chart sheet.

View 13 Replies View Related

Sum A Table Without Putting Individual Answers On Each Row

Apr 22, 2009

Would like to sum a table without putting individual answers on each row and summing column. The table can consists of 100's of rows but only 3 columns.

lbsratehrs
Item 1100.10
Item 250.525
Item 3200.2550

Total Lbs/hr0.2 (answer)

Find lbs/hr for each item and sum all items lbs/hr
(lbs*rate)/hrs

View 3 Replies View Related

Putting Text At The End Of Formula Results

Jan 8, 2010

I'm trying to enter relatively simple drug calculation formulas in Excel where the result is appended with the proper units to administer. For example, if I'm calculating for units of regular insulin with a formula such as:

=0.75*f2

I'd like the cell to make the above calculation, and append it with "Units Reg Insulin" or something similar. Thus far, I've just been putting the units as text in adjacent cells but the result looks a bit messy.

Is this possible? I'm using Excel 2007 and the Help index does not seem to offer much guidance about this.

View 8 Replies View Related

Taking Row Of Spreadsheet And Putting Into Main One

Nov 29, 2013

I have a bunch of spreadsheets in a folder and I need to take one line of each spreadsheet (which is in the same place on every one) into a master spreadsheet.

I am always adding to the spreadsheets in the folder.

Is there a way to have my master spreadsheet look out for changes in the folder and when there are changes add the row into it?

View 2 Replies View Related

Putting Input Box Into Existing Code

Jan 22, 2009

On the "If not Isempty" line, I am trying to input a box prompt. Instead of standardizing this macro, I want the user to be able to select a dollar amount to search and place on sheet3. Right now it works fine using 1.29 as the amount. However, I have other stores where this dollar amount is different, so I want the store managers to be able to choose an amount to search, for example 1.39, 2.99 etc...

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved