I have 1000s of rows of data wherein there is no space or full stop once the sentence ends and a new one starts. For example,
Original text: Bob is a boyJanice is a girl.
What I want: Bob is a boy. Janice is a girl.
How to create space between two consecutive capital letters?
like i have....
RPerry
RCCox
i want...
R Perry
R C Cox
How to create space between two consecutive capital letters?
like i have....
RPerry
RCCox
i want...
R Perry
R C Cox
I just want to conditionally format some columns with different colours. The problem is that I have some cells that have the value 'a' and others that have 'A'. These should be different colours, but I can't seem to get Excel to detect between the two forms.
View 9 Replies View RelatedI have a validation drop down box type thing... when I select the drop down, the lower-most option is highlighted as a default. How do I make it so that the upper-most option is highlighted first?
View 9 Replies View Relatedhow can I seperate small and big letters from one collumn, example:
NAME
name
NAME
NAME
name
name
How you can print cells that have a large amount of text continuously on every page (like in an MS Word document)? I have cells that end up with a lot of text, but excel will push the next text heavy cell to the next page leaving you with a few inches of white space on the previous page. Is there a way to just continue the printing of one cell onto the next page to make all the pages even? It takes up extra paper and looks bad when printed...
View 3 Replies View RelatedI have a series of text - domains actually (i.e. goldintre.cr.usgs.gov.) - and I need to extract the text that appears before the first period in one cell, and the text that appears after the first period. Both have to be without the periods. So in the above example the result should be 'goldintre' in one cell and 'cs.usgs.gov' on the other.
View 3 Replies View RelatedI'm working on an email database and am looking to sort them into type. I am trying (without success) to use the IF function as follows.
If A1 contains the letters "isd" consecutively, then B1=TRUE
If A1 contains the letters "google", "yahoo", "hotmail", or "austin.rr" consecutively, then B2=true
I am just looking for a way to use the find function but only to display results that end in what I am looking for. For example i am trying to find a sequence of numbers/letters that end in a. If I do a find it displays results for anywhere there is a . in the sequence. I would like just the ones that end in the.
View 2 Replies View RelatedI've got this code to display a certain cell from multiple files, and functionally it works, but I get a out of stack space error after it runs for a while. I'm sure this is because the loop doesn't know when to stop, which I thought would be solved by having " Do Until sBook = "" " instead of Do; however, then the code will not run at all.
Private Sub Worksheet_Calculate()
Dim sBook As String
Dim sFilePath As String
On Error Resume Next
Application.EnableEvents = False
Roe = 3
Do
Looking for a way to insert small photos into a excel spreadsheet.Would it work with data validation or even a lookup table.The photos need to be inserted every 8th row.Is it best to name each photo?I`m not started yet as i not sure if this is even a possibility but if there are ways i will make an attempt...Maybe a VBA code could automatic insert them when a button is selected..they are 2 columns x 4 rows in size the photos
View 3 Replies View RelatedI'm trying to make a excel template that will take a list of names, changes but generally around 100, and randomly separate them into 4 sets of 8 groups evenly.
This grouping would be repeated 4 times, but there are some conditions.
Firstly, the same person cannot be put into a group again with someone they have previously been grouped with.
Secondly, someone appearing in the first or last groups cannot appear in that group again.
I've been trying to do it via some complex cell formulas but they are quickly becoming overly complex and im not sure if it will actually work which has completely demotivated me. Ive not been looking at VBA but am now thinking its the right route. Ive been thinking of having a master list and then have an attribute of who people have been grouped with before during each of the groupings, and also what number group they were in and then checking against that or something, but im not sure if that is the most efficient solution.
I attached an example dataset : demo dataset.xlsx
I have a file that has been produced using Statistica software. The file is supposed to have around one million rows, and when exported to Excel the file is about 30 MB. When I open the .xlsx file in Excel 2010 only two pages of data appear. The rows also have weird numbering. The first square of the A column is A1. The second is A3833, the third is A6789, then A8161, then A8162, then A8163, then A8164, then A18070.
The scroll button to the left of the screen is long, as if the document was only two pages long. When the scroll button is click-and-dragged a small beige square appears with a row number. This small square seems to be aware that not all rows are shown as it shows many more rows than are visible to me.
In a particular CSV Excel file I want to populate "Description" column with a HTML template Code by merging 3 columns of HTML. The HTML has almost 20,000 characters. Now before merging and after merging when I copy paste the HTML in any cell it doesn't show all the code that I have copied. and when I merge all the 3 columns. a lot of HTML data seems to be missing. I think excel has some sort of limit and it is not allowing all these 20,000 characters merged and combined in 1 cell. I am stuck at this point and can't upload the CSV as the HTML is missing a lot of coding.
View 2 Replies View RelatedI would like the full path in the excel 2007 title bar automatically every time I open a excel file.
The macros I try from other sources all end up in errors. I need step by step instructions.
I had a spreadsheet with 17 photos on, one in each cell. I had to resize so you can see them all on the screen. If you have some pictures that are resized to fit in cells, is there any way to double click (or hover?) them and make them actual size or full screen when you want to view them in detail?
View 2 Replies View RelatedCode:
Application.ScreenUpdating = False
Dim c As String
Dim d As String
[Code]....
this works perfectly but I have found one problem, I want excel to find on the existing arrays "0,00" and "0", only full match and not only partial like for example:
-154.09, which triggers "0" for the second array and 120,00, that triggers "0,00" how to I change to only find full match with the existing arrays?
My Excel 2010 spreadsheet contains client data like the below:
A
B
C
D
E
What I'm trying to get from this is a personally addressed email with 2 attachments, one will be standard to all recipients and one will be unique and specific to that recipient. The filename of the unique attachment will contain the reference but will have some other stuff in the filename as well on either side that I will not be able to remove.
In terms of the file locations the unique ones will be in subfolders of the folder holding this workbook and the generic one will be in the same folder as the this workbook.This is some adapted code that solved a similar problem (in Excel 2007 though) on a different website.
VB:
Sub Mail_Report()
Dim OutApp As Object
Dim OutMail As Object [code]....
In that case the file started with the "reference" field but in my case it is in the middle and the formats vary depending on the provider, there will only be a maximum of 5 providers but I would like to avoid 5 different macros if at all possible so I need a search function of some sort.
I need a formula that will count the number of consecutive 3 0's from the following Data series. There are 22 such events.
0
6
15
[Code].....
I'm using Excel 2010. I have a workbook with only 1 worksheet in it and it will be sent to several people. I want that excel file to open in Full View when the end user opens it. Is this possible without any VBA codes?
View 2 Replies View RelatedI would like a formula to track consecutive odd/even digits.
Odd= 1,3,5,7,9 consecutive 135,357,579,791 any order of those values.
example 135,153,315,351,513,531
Even= 0,2,4,6,8 consecutive 024,246,468,680 any order of those values.
example 024,042,204,240,420,402
If no CE or CO, return N
Sheet1BCDEF1103/29/14208CE1203/29/14913CO1303/28/14462CE1403/28/14795COExcel 2007
I have some rows that have some text for example "0- 56933 tex". the numbers are not always the same, but there is a dash, and sometimes there is no space after the dash. I want get the numbers before the dash in a variable and the one after in another variable.
View 9 Replies View Related how to display Sparkline from non-consecutive cells.
I want to display it from two apart ranges: A1:C1 and F1: J1
If it can't be done within the worksheet - is there a VBA code to workaround - such as filling-in an Array from the non-consecutive and using that Array as the Sparkline source ?
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 RelatedI 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
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?
1.jpg
I wan to calculate the average for three cells not in Sequence using AVERAGEIF with condition (VALUE >0)
My columns became numbers instead of letters. How do I switch it back to letters?
View 5 Replies View RelatedI need to delete the last 3 character from a colon, but the problem is that the Colon will be deleted after.
Let me explain:
National
453386855
National
453386567
National
453388587
With the formula =LEFT(A2,LEN(A2)-3)
I will have this:
National
453386855
453386
National
453386567
453386
National
453388587
453388
But I need to delete the second colon, and I will have this:
National
#VALUE!
National
#VALUE!
National
#VALUE!