TextFrame.Characters Behavior
May 31, 2009
I use the command
ActiveSheet.Shapes("ZoneTexte " & R_Box).TextFrame.Characters(Start:=1, Length:=10).Font.Size = 10
To modify the Font.Size the 10 first characters in my textbox.
Work fine the first time. Problem occured when the same macro is called for the second time in the same textbox.
Problem: I got 20 of the first characters font.size modified instead of the first 10. Calling it a third time, i will have thirty characters. The start :=1 seems to be modified.
Strange and i have problem to explain it using my FranGlish language writing
View 9 Replies
ADVERTISEMENT
Jul 12, 2007
Some option must've changed recently in my excel spreadsheets by accident and now when I hit the enter key it doesn't drop down to cell in the next row, it just stays there.
View 5 Replies
View Related
May 8, 2008
I am trying to assign a macro to the Print button on the Standard Toolbar. Basically I want that button to print the number of pages I've specified in a cell, but I still want to be able to use the 'File/Print...' option if I need to.
I did try to solve this issue in an earlier post, but this exact problem remained unsolved. For more information
http://www.excelforum.com/showthread...89#post1916589
View 13 Replies
View Related
Oct 13, 2007
For example. Dragging c7 to e5.
My range before dragging and dropping...
After the drop.
What do you think? I think it can be done but do not want to waste time going about it the wrong way. Please give me any ideas on how you would approach this problem.
Some information to start with. The modal dialog that pops up can be dealt with.
This one.
I can determine if I want to insert down or up. I am not concerned with shifting left or right at this point.
I can also determine the original address and destination address of the drag and drop operation by using the change event.
The ranges being dragged will be limited to a single cell.
View 9 Replies
View Related
Dec 12, 2005
A client of ours has one particular file that has some very strange behavior as described below. This only occurs with the one particular file and the behavior is consistent across different PC's in both their office and ours. All other Excel files in both offices work fine. Here's what happens:
- you can use Windows Explorer to copy the file between drives without
a problem (as expected)
- if you open the file in Excel on one drive then save it back to that
same drive with either the same file name or a different file name, the
file works fine (as expected)
- if you open the file in Excel on one drive then do a "Save As" to
save it to a *different* drive with either the same file name or a
different file name (in default .xls format), the new file causes
errors in Excel every time you open it as per below (weird!)
- even if you do a "Save As" and choose a different format eg Excel
97-2003 or Excel 95, the error behavior is consistent (weird!).............
View 2 Replies
View Related
Jan 17, 2012
Is there an Excel formula to remove the spacebar + characters in red, as shown below? I need to be left with only the last name, first name and the semicolon.
Mouse, Mickey ;
Microsoft Outlook has changed the way that email addresses from the global addressbook copy and paste (from version 2003 to version 2010).
View 8 Replies
View Related
May 13, 2009
I'm trying to use conditional formatting to highlight cells in a column that have less than 8 characters.
I know the LAN function, but I don't know how to make it work for the conditional formatting.
View 9 Replies
View Related
Aug 1, 2014
So we have people's names in a table. First name in one column and last name in another column. We have a 3rd column where we can use 8 characters to do a combination of First 5 of Last Name + first 3 of first name. However, if someone's last name is only 3 or 4 characters, we'd then want to take more from the first name to fill out the 8 characters.
So:
Charles Johnson -> Johnscha
John Smith -> Smithjoh
Willian Wu -> Wuwillia
What's the best way to do that without creating some crazy formula with tons of if/thens?
View 4 Replies
View Related
Sep 14, 2009
I have a string of names that run together without spaces or commas between each name.
"Danny TrejoJean Claude van DammeVincent SchiavelliGabrielle FitzpatrickDavid 'Shark' FralickPat Morita" for example.
Is there a way to add a comma and space when an upper case letter is immediately followed by a lower case letter?
View 4 Replies
View Related
Feb 23, 2010
How can I make combobox have only first 18 characters from a cell to appear, Have tried max lengh to 18 but still on the output it shows the full string... or an alternative how can i fix sheet column to 18 characters input ????
View 2 Replies
View Related
Jan 10, 2014
Ok so my formula simply wants to substitute a really long string of text with a blank cell. Problem is that the really long string of text goes over the 255 char limit for a formula.
How can I go about solving this problem. I think you could name the string of text as a variable such as "long text" and then use the substitute formula as such:
=SUBSTITUTE(A1,"long text", "")
Something like that? I don't know if it would work or the steps to name the variable.
View 6 Replies
View Related
Feb 17, 2014
I'm trying to make a chart viewer on the first sheet of my spreadsheet and am using this website as a guideline, [URL] However instead of the 3 charts in the example, I have 12 which makes my formula for defining a name substantially longer.
By moving my charts to the same sheet and getting rid of the INDIRECT formulas, I shortened my formula to 291 characters which is too long as the limit is 255.
=IF($G$9="Sodium",$N$34,IF($G$9="Manganese",$N$35,IF($G$9="Iron",$N$36,IF($G$9="Nitrate Nitrite",$N$37,IF($G$9="Nitrite",$N$38,IF($G$9="Nitrate",$N$39,IF($G$9="PH",$N$40,
IF($G$9="Conductivity",$N$41,IF($G$9="Turbidity",$N$42,IF($G$9="Fluoride",$N$43,IF($G$9="Selenium",$N$44,$N$45)))))))))))
Is there any way to make my formula shorter? Or to reference a cell where I place the formula?
View 5 Replies
View Related
Jun 2, 2009
When I try to enter 18 numeric characters in a single cell, the last three characters are converted to zeros. I can find no format that would allow me to see all 18 entered characters. Is there a way of doing this?
View 2 Replies
View Related
Jun 9, 2009
I've searched Excel's Help but still unsure how to do this. I hope excel experts here can lend me a hand...
I have literally thousands of words in a single columns column which looks like this:
absah
absen
absenan
absensi
abses
absis
absolusi
absolut
absolutisme
...
...
...
etc
My question is what formula if i'd have to enter to add three spaces between characters and five characters at every end of the word so it should look like this?:
a b s a h .
a b s e n .
a b s e n a n .
....
....
etc
Note i have entered a full stop at the end of the example above to make the five spaces visible in this demonstration (I dont need the period character inserted at all).
View 12 Replies
View Related
Jul 6, 2009
I have a table that have a test or character and value (number) like
A 5
B 6
C 3
And another table that has a set of characters that I want to sum the value of the characters like
A B C 14
So that the result of summing the characters will be in the next cell.
View 11 Replies
View Related
May 22, 2013
I use excel for keeping a database of all the movies I have seen.
My problem is in regard to the value of characters. I sort my movies by default alphabetically and am wondering if there is any way to exclude the word 'The' from the sort. Traditionally when movies are sorted alphabetically, that word does not count, but obviously my problem is that excel is indeed including it.
There is also another problem regarding the value of characters. When I rate movies less than a '6' I would like to write it as "<6". The problem is that excel actually reads the "<" symbol as being of greater value than numbers and will put any movie rated "<6" at the top of the row when I sort largest to smallest. Is there any way to change the value of the "<" symbol so that my movies rated "<6" will be sorted below all my other rated movies?
View 12 Replies
View Related
Jul 7, 2014
I have a code that acts a little like pivot tables where it copies a few columns from the workbook into a different sheet.
The thing about the new sheet is that under column G i only need the first 6 characters and not the 3 words that follow it.
I was able to get the code use only the first 6 characters but it extends to the entire sheet!
How to limit this to only column G as opposed to the entire sheet?
View 6 Replies
View Related
Jan 29, 2014
I need to remove/trim in column B the last three characters in each cell so that I am only left with the first 12 characters.
View 3 Replies
View Related
Jan 2, 2009
I have a column that has all the digits in the phone number. What I would like to do is remove the first 8 characters example 111-222-3333. I want to remove all the ones dash twos and dash. Can someone help me please ?
View 7 Replies
View Related
Jan 9, 2009
I have a coumn starting from A2 onwards that holds data with various characters, all that i require is the 1st 9 characters (These are always numbers).
View 6 Replies
View Related
Dec 16, 2009
cell A1 contains:
001001 28 EA 12 CATALOG #: 9358171
I would like to get all the characters in between the word EA and CATALOG and put them in B1 and so on....
View 2 Replies
View Related
Jan 28, 2010
I have a spreadsheet which I use to enter notes related to particular invoice numbers. A v-lookup pulls the notes into another tab. What I'm running into is that the notes can be quite lengthy - in excess of 1,000 characters. When the notes get too long, they don't all appear in a single cell (unless it's extremely wide).
I'm wondering if there may be a way to maintain my notes in a word doc instead? Maybe in a table that pulls in using a v-lookup? But I'm not able to figure out how to direct a v-lookup to a word doc.
View 10 Replies
View Related
Mar 22, 2012
In my worksheet, column C contains a list of part numbers of various lengths.
How do I copy the part number without the last 3 characters & paste in col D?
I don't mind if this is achieved using VBA code or excel function.
View 4 Replies
View Related
May 15, 2012
Im trying to write a macro to delete the last 5 characters of a cell,
Its the whole column to which i need to apply this to
View 8 Replies
View Related
Jun 17, 2013
I'm trying to find a formula to add a "Y" to the beginning of a value less than 7 characters and and not to add a "Y" to the beginning value that is equal or greater than 8 characters.
This is how I need it to look.
Y123
Y1234
Y12345
Y123456
Y1234567
12345678
View 8 Replies
View Related
Oct 7, 2013
I am very new to macros I have a list of data all in column D. I need the macro to go through that whole column and for any cell with more than 50 characters stop at 50 and continue the remaining text in the cell below. This can all happen in column E.
View 8 Replies
View Related
Jan 13, 2007
I have a cell that contains BYO CUSTOMER XYZ 76458992
I want the cell next to it to remove all of the letters and display only 76458992.
View 9 Replies
View Related
Feb 19, 2007
I have a keyword list in ColA. about 25,000 phrases.
What I want to do is create a macro button.
when i click on it a pop up box would appear called "Deleting Characters"
It will have to 2 rows, 1 saying "More Than",, the other saying "Less Than"
So, beside these words are input boxes.
So I can type the numbers "2" and say "50"
So it will look at all the rows of data in my ColA (Always from A3 downwards)
and deletes all rows with less than 2 characters and more than 50 characters.
When it is finished a floating box appears saying
"123 Characters Less Than 2 Deleted"
"101 Characters More Than 50 Deleted"
Sub NoOfCharacters()
Dim lastrow As Long, TotP, TotC, AvC
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
If lastrow < 4 Then
MsgBox "Nothing to sort!"
Exit Sub
End If
Range("B1").EntireColumn.ClearContents
Range("B3").Formula = "=LEN(A3)"
Range("B3").AutoFill Destination:=Range("B3:B" & lastrow)
Range("A3:B" & lastrow).Sort key1:=Range("B3"), order1:=xlAscending, Header:=xlGuess
TotP = lastrow - 2
TotC = Application.Sum(Range("B3:B" & lastrow))
AvC = TotC / TotP
MsgBox "Total No Phrases: " & Chr(9) & Chr(9) & Chr(9) & TotP & Chr(13) & "Total No Characters: " & Chr(9) & Chr(9) & TotC & Chr(13) & "Avg No Characters Per Phrase: " & Chr(9) & AvC
End Sub
View 9 Replies
View Related
Jun 5, 2008
let's say row 2 has data that looks like
apple (kg), apple (g), orange (kg), orange (g)
it is possible to remove the (kg) and (g) tags so that it'll become
apple, apple, orange, orange
using VB code?
View 9 Replies
View Related
Mar 30, 2009
I have 62,000 lines - and some of the cells contain 4 numbers, and some of the cells contain a sequence with two letters followed by 8 numbers
I want to count how many cells have the sequence of two letters and 8 numbers.
Everything Ive read so far has led me to using the LEN function, but that doesn't seem to be working too well for me.
Example: In D5 if I have AB00011111
Basically =LEN(D5) will tell me there is 10 characters in the cell - How do I get it to count the cells with only 10 characters and post the number of cells with 10 characters in column E1 for me.
View 9 Replies
View Related
