Combining Words In Cells
Feb 13, 2009I'm looking to take words which are originally in their own separate cells and "combining" the words all into one single cell.
Is there a function that will be able to do this for me?
ADVERTISEMENT
Combining List Of Words Into New Words, Conjugation
Feb 15, 2007I have 4-5 separate lists of words/letters and I would like to combine them in a certain order but creating all possible combinations resulting a new word. It's like a conjugation tool for verbs. For example if List 1 = be/el/ki/meg; List 2= m List3=e/é; List4= gy/" "; List 5=" "/ek/sz/nnek So the output has to be (if the order is List1+List2+List3+List4+List5)= bemegy/bemegyek/bemegysz/bemesz/bemész/elmegy/elmennek/ ..... and all possible combinations.
Preferentially I would like to automate it in a way that it straight outputs into MS Access. Also can it be automated that it reads the list from a file (database)?
(Also can it recognize the word by letters? Because the basic word that I would load the program= List2+List3+List4)
Combining Two Or More Cells
Sep 28, 2009I know a simple formula would 'almost' do what i want...but i was hoping for a simple feature....
i have several text cells that i want to combine into one cell.....
so a formula like =A1&B1&C1.... would work fine....but is there anyway to present this data a little fancier? for example separating each cell entry after a "break" or something....
Combining Text From Two Cells
Apr 29, 2009I have two columns, Brief Descriptions and Detailed Descriptions. In many cases they are different and I combine the two for one longer description; however in certain instances the two columns read the same. Is there was way to combine the two cells where any repeat text is only expressed once?
View 3 Replies View RelatedKeep Date When Combining 2 Cells
Dec 29, 2009I'm trying to combine 2 cells: 1/1/09 and ABC. However, when I combine them the date keeps changing to a number. Is it possible to keep the date format?
View 2 Replies View RelatedCombining Cells Into One Cell
Sep 17, 2009I am trying to combine multiple cells into 1 cell per row.
I would have "A" column empty, then combine "B", "C", and on into the "A" column.
Each cell value will be separated by a space or any special character I designate in the macro
I have attached an example which the output is separated by a space. Sheet1 has the original file and Sheet2 has the desired output.
Combining Parts Of Two Cells
Jul 27, 2009I have a list of dates in column A as follows:
11/1/2015
5/1/2012
8/8/2013
10/22/2015
4/1/2014
4/15/2014
In column B I have set of data as follows:
C 2010@101.0
C 2011
C 2011@101.0
C 2012@101.0
C 2013
C 2013
C 2014@101.0
I need to combine the day and month only in column A with the year (in positions 3-6) in column B
As an example I have "11/1/2015" in column A and "C 2010@101.0" in column B. The desired result in column C is "11/1/2010".
I have tried using the left function in column A with the mid function in column B but haven't had any luck so far.
Combining 2 Cells To 1 With Date
Jan 11, 2010I am combining information from two different cells to one cell using cell reference such as,(=B4&"/"&F5),B4 being a number and F5 the date. So my question is how to get the date to show as a date value and still have the other value remain unchanged. I have tried to use formating but will not work to keep the date. An example would be
View 2 Replies View RelatedCombining Data From 2 Cells Into One
Apr 17, 2006I have a spreadsheet with a name spread over 3 cells
A1 = MR
B1 = JOHN
C1 = SMITH
i want to create a macro or a formula that combines all of the data in these cells into the first column so that in column A1 it would read MR JOHN SMITH.
Cycle Through Combining Cells
May 9, 2007I want to combine cells from two adjacent columns in this way: a1 is combined with everything in column b, then a2 is combined with everything in column b, etc. So that I have a1b1, a1b2, a1b3, a1b4, a2b1, a2b2, a2b3, etc.
View 9 Replies View RelatedCombining Two Text Cells Into One With Hyphen In Between
Jan 30, 2013I am setting up a new chart of accounts, with the format xxx-yyyy, where xxx is a three digit department number, and yyyy is the expense account. I am building a spreadsheet to populate the new chart of accounts to be uploaded into our accounting software. I would like to have a cell that takes the xxx from one cell, adds a hyphen, and combines it with the yyyy value. The result would be xxx-yyyy format.
View 3 Replies View RelatedCombining Cells (strings With Spaces)
Nov 21, 2013I have the below data that I need to concatenate, merge... I'm not sure.
The data looks like this currently:
So that it reads in one sentence, e.g. Northumberland; Newcastle; North Tyneside; South Tyneside (note - no "." or ";" at the end of the string).
I had come up with this formula -
=IF(A11>0,A11&"; ","")&IF(B11>0,B11&"; ","")&IF(C11>0,C11&"; ","")&IF(D11>0,D11&"; ","")&IF(E11>0,E11&"; ","")&IF(F11>0,F11&"; ","")&IF(G11>0,G11&"; ","")&IF(H11>0,H11&"; ","")&IF(I11>0,I11&"; ","")&IF(J11>0,J11&"; ","")&IF(K11>0,K11&"; ","")&IF(L11>0,L11&"; ","")&IF(M11>0,M11&"; ","")&IF(N11>0,N11&"; ","")&IF(O11>0,C11&"","")
Which works fine if there is a value in cell O, but if not, then a semi-colon appears at the end of the string. It also seems incredibly clunky.
Basically, I'm struggling (being a total n00b) to get the semi-colons in the right place, blank cells to be skipped or not included, and for there to be no semi-colon after the last value.
Leading Zeroes And Combining Cells
Mar 4, 2014I currently have a column with each cell containing alphanumeric data of a filename.
The majority of cell data looks something like this.
"AB_XYZ_0408_00700.doc"
"AB_XYZ_0408_00708.doc"
"AB_XYZ_0408_02200.doc" etc
**Note the numbers "00700" are always 5 digits long also note the extension is always ".doc" (4 characters long). However the other parts, AB_XYZ etc vary in length based on the worksheet.
I need to ADD or Subtract "+1" or "-1" from the 5 digit number for example make "00700, into 00701"
I currently tried to separate the data into columns which provides me with the number 00700 isolated in its own cell and then I simply add or subtract 1. In that isolated cell I am able to add "leading zeroes" and it works great.
The Problem is that when I combine the separated cell data "=A1&B &C1" with the New number (in this case 00701") the problem that I run into is the leading zeroes do not follow over to the combined cell and I am left with a final filename like this "AB_XYZ_0408_701.doc" - That is missing the leading zeroes.
Also if you have a more advanced formula that could simply add and subtract "1" from the 5 digit number that would be ideal.
Combining If, Offset And Range Of Cells
Feb 13, 2007i need to get an equation correct for a scheduling application
assume $f24 is a task frequency and U24 is our current cell location
=IF(OFFSET(U24,0,(-$F24+1),1,($F24-1))"","","X")
i am asking if (the range of cells to the left of current cells (range being task frequency -1 columns wide) are empty - and if so - put an x - if they are not empty - then leave it balnk.
i can get it to to work for a 2 weekly schdule but need it to work upto 52 weeks
i have a simple spreadsheet with the problem clearly defined for anyone who can help
- beer in it for anyone who can help - or can pay via paypal if required
Combining An Unknown Number Of Cells Into One
Nov 4, 2009I have the following setup,
Down column A I have a list of jobs, job 1 , job 2 etc
Down column b I have either a blank cell or other data (will be numbers but is irrelevant)
What I want is a formula for a cell that tells me which titles in column A have any data at all in column b. I need it to look like the following : Job 1, Job 2, Job 4
assuming b1 b2 and b4 have any contents and b3 and b5 and onwards are empty
I am seeing that concentate gives me close to what I want but the number of rows in column a and b change constantly and also may be above 30
Combining Rows With Merged Cells
Aug 10, 2006I am generating a calendar view of project information in excel with the column headings as dates. Every project should be a merged group of cells spanning the rows for the proper dates.
Right now I generate a new row with new merged cells for every project (100 projects = 100 rows, even if the project only spans a single day!)
I need to be able to consolidate the project data so that if two projects' dates don't overlap they are put in a single row.
For instance:
Project 1 runs 8/2/2006 - 8/3/2006
Project 2 runs 8/5/2006 - 8/9/2006
Project 3 runs 8/6/2006 - 8/7/2006
Right now I get 3 rows, each with one piece of data shown as a group of merges cells.
I want to see Projects 1 + 2 or 1 + 3 on the same row (since they don't overlap).
Simply cutting and pasting up doesn't work because the vba automatically overwrites data.
I just don't know excel vba very well (long time access man).
Sum Up Cells Containing Certain Words
Jul 27, 2009im currently wonderin if the SUMIF function can have a WHERE syntax?
because i want to add up cells which contain these:
A B
1 VC-ON US 2
2 MC-ON US 5
3 MC-OFF US (STD) 8
4 VC-OFF US (PREM) 9
in another separate cell, i want to retrieve the sum of numbers with the words ON US in column A. so the final result will be 7.
Replace All The Times That These Words Appear In The Rest Of The Sheet With The Words In Column B
Sep 20, 2006I have a column of words in Column A and I want to replace all the times that these words appear in the rest of the excel sheet with the words in Column B. If someone has already answered a similar problem link me to the thread because I can't find anything.
View 5 Replies View RelatedCombining Two Spreadsheets - Marking What Cells Have Been Pulled Over?
Mar 14, 2014A little background, I am trying to match CC deposit batch transactions to daily sales transactions. I have two reports, one from our credit card processor/gateway (Report "B") and one from our software where the daily sales (Report "A") are recorded. I used the INDEX/MATCH formula to pull the information I needed from Report "A" into Report "B". It worked perfectly. My question is, is there anyway that I can show what information has been pulled from Report "A"? Possibly by highlighting what was pulled over? It is a longshot, but it would make my life so much easier if it was possible...
View 1 Replies View RelatedCombining Cells Into One, But Seperated By Carriage Return
Feb 8, 2007I have rows of data in one column. I want to combine them all into one cell and have each row on a new line.
I've tried =A1 & char(10) & A2, (and a bunch of other char(#s) for carriage return) but it just shows an open box in place of the char().
Combining Cells Based On Value Of Adjacent Cell.
Jan 11, 2009I have been reading through trying to find a similar post but the nearest i could find was one dealing with numbers rather than text. This is how the workbook looks.
Column A contains a list of numbers based on vehicle types. Column B contains a list of vehicle names.
A B
1 Car,
1 Taxi,
2 Bus,
2 Lorry,
3 Skateboard,
3 Bike,
1 Motorcycle,
What I am looking for is the best way to combine the text from column B depending on the value of column a. the finished results would then end up as: "Car,Taxi,Motorcycle,", or "Bus,Lorry," etc. This is just a simple list.. The one I am working with has around 2500 entries. I have been trying to do this using the CONCATENATE function and IF statement but it's just not working..... My head is ready to explode
Macro To Return Value By Combining 2 Cells & Finding Mat
Dec 15, 2006I have a step in a very long macro to populate a sheet (SheetMaster) with the course completion status based on another sheet (SourceData) in the same workbook.
On "SheetMaster" Col E starting with row 2, I want to look at whether a concatenated value of E1 + A2 is in Col G in "SourceData". The macro should run until it gets to a blank row in Col A.
Here is an example to help illustrate the logic:
E1 = Ethics101
A2 = 123456
A3 = 654321
If Col G in "SourceData" contains "Ethics101-123456", E2 = "Complete", if not "Incomplete"
If Col G in "SourceData" contains "Ethics101-654321", E3 = "Complete", if not "Incomplete"
...and so on until it gets to a blank row in Col A...
Change Text Color While Combining Cells
Jul 21, 2008Is there a way to combine cells in excel and chage the color of part of it?
Example: On my sheet I have multiple cells I need to combine:
Say A1 reads 23.65
Say A2 reads 43.65
Now on A3 I want it to read "Estimated budget 23.65 vs 43.65"
I can get this to work but here is the problem, I want the 23.65 to always be red and bolded and the 43.65 to always be blue and bolded.
Show Cells That Contain 2 Words
May 5, 2009I have a list of names, some have first name and surname (in the same cell), and some just have first name.
Is there anything I can do to only show the cells that contain a first name and surname?
Seperating Words To Different Cells
Jun 23, 2009I have hundreds of file names, and to cut a long explanation short, they are exported as a CSV file to excel. In order indentify the owner of the file I need to rename the file with a commar where you see the dash or the underscore in order to have the name appear in the next cell, as can be seen with Syma and Kevin below, so I can then sort the columns etc etc.
I know there is a formula that I can use to achieve this, ie have syma.pdf and kevinc.pdf in the next cell.
I think it works on identifying how many characters along the name and then send i to the next cell.
as you can see below, there is no set amount of characters to put into a formula.
Could I say, for example, if after dash /underscore put next word in next cell?
t5 mon a2 w6-syma-0003.pdft5 mon cst w2_dellwynneh.pdft5 mon a23 w3_MASUMS.pdft5 mon cmn201a w1- syma.pdft5 thurs wiabe w2_kevinc.pdft5 thurs wiabe2 w2_kevinc.pdf
Extract Certain Words From Cells
Aug 13, 2007i have a column where the sponsor has a name of a race and i wish to remove the sponsors name and replace it with something of the sentence
for example
Barton And Guestier Top Novices' Hurdle Class A Grade 2
i wish to just locate the Novices' Hurdle part and change that particual cell to nov hurdle without the sponsors name
is it easy to extract this info
Clearing Cells Containing Specified Words
Apr 29, 2008I am trying to clear the contents of cells in a very large spread sheet containing certain words. I am running the following macro and it will only do the first part, so it will clear cells containing "deceased" but stops at "esa". There may be any number of other words or text in the cell and I want it to delete cells with "esa" by itself so for ex. not delete cell containing "vanesa". I am very amateur so I am sure this is something simple but I cannot find the answer or figure it out for myself.
Sub DeleteAll()
Dim lCount As Long
Dim rFoundCell As Range
Dim rLookRange As Range
Set rFoundCell = Range("A1")
Set rLookRange = ActiveSheet.UsedRange
For lCount = 1 To WorksheetFunction. CountIf(rLookRange, "*deceased")
Set rFoundCell = rLookRange.Find(What:="deceased", After:=rFoundCell, _
LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False)
rFoundCell.ClearContents.......................
Macro To Only Keep 100 Words In Range Of Single Words Per Column?
Jun 3, 2014I'm looking for a macro to remove all words (in a single word per cell format) in a range (approx 100 columns & 7000 rows), except for a list of 100 words.
I'd prefer to email the file if that's okay.
Auto-calculate 2 Column That Contains Numbers And Words Words
Jul 16, 2009I've been using conventional method to do this and it's time consuming. I would like to total up 2 column. A multiply B to be exact. Below are some examples:
Table 1 - Before totaling up:
Quantity
Product
5
2 x Button A White
3
4 x Button B Pink
4
5 x Ribbon A Black
2
3 x Thread A White
6
2 x Cloth A Blue
Table 2 - After totaling up:
Quantity
Product
10
Button A White
12
Button B Pink
20
Ribbon A Black
6
Thread A White
12
Cloth A Blue
I need to have the sum of the "Quantity" multiply "Product". Or in short A x B.
And the end result need to have the number and "x" sign removed while keeping on the the products names. (2 x ) Take note it's "number" space "symbol" space.
Separating Words In One Cell Into Many Cells
Jun 12, 2014All words are in Cell A, separated by the ";" symbol. I want separate into different Cells. Example... Lead_ID in Cell A1, Application Data in A2, Date Purchased in Cell A3 and so on.
lead_id;application_date;date_purchased;first_name;last_name;email;day_phone;work_phone;
best_time;city;state;zip;addr;cred_rating;cred_score;yearly_income;prop_state;prop_type;purpose;
loan_amount;prop_value;ltv;mtg_bal1;mtg_bal2;services;credit_repair;foreclosure;debt_management;comments