concactenate

Hello all, I have a bit of a challenge here if anyone can help. I'm not entirely sure if it's even possible but I'm sure I've seen someone do something similar on a YouTube video but I may be mistaken. I want a formula (or formulas) in the range B8:O19, which will pull back information from...

Hello, I am having trouble setting up a document. I am currently using Concatenate with an agents name and date to form a unique ID for that week. I am then trying to bring that data into a new sheet which marks the percentage 1-5 based on ranges. I have attached an example sheet but I can...

I want to =CONCATENATE 'Column I' occurring of next number in 'Column H' as per attached picture expected result in 'Column J'

I have the following stored in a string (can be in a cell as well, if needed). Let's say s_String1(2,1) or cell A2: This text is permanent //Changeable-Text-Starts-Here This text can be changed by macro //Changeable-Text-Ends-Here This is also permanent I want to be able to remove...

Hi... I required little help in making an entry employee wise with the data available. In a file, I'll be having 2 sheets DATA & ENTRY. I should use the DATA to make available of the ENTRY individual employee wise. DATA Sheet <colgroup><col><col><col span="6"><col...

for example: can a word in a cell "star" be extracted into another cell as "s.mp3,t.mp3,a.mp3,r.mp3"? the words can be a of varied length .. the final output can be concatenated .. but the issue is that the words can be of any length .. example - "ant" or "butterfly" or "enlightenment" .. i...

I have a worksheet with data in it from Cols A-U and a variable number of rows. In col V I want to concatenate the data in cells A and E for every row that there is data. So far I have set a range that is all the cells in col V that I want to concatenate A and E for but I'm not sure how to...

I'm working on a pretty simple Macro in excel to delete several columns in excel. There are 10 columns and 5 are deleted. The last step of the of the Macro is to Concatenate 3 cells and then copy the formula down. My challenge is let's say this month there will be 100 records, while next month...

Hello All,:eeek: I have searched in your site for a solution for my problem, and have tried various solutions for similar questions, modifying some, but without success. I am running Excel 2003. I have a row of cells, the whole width of the Excel display, each cell containing a formula that...

Hi there, I have a very complex workbook spread over 2 sheets and need some help searching and sorting through my data using a formula (not a macro). I have a sheet called 'Initial List' with lots of names in one column (column F) and the document numbers that that legislation is referred to...

Hello all, I searched around on the forum for an answer for this, and I found some solutions that were close. I was not successful at adapting them to my needs (and I feel like this should be easy!). I have a spreadsheet with testing data (quality control tolerances), so there is a column...

Hello, This is my first post, please be patient. I will put as much detail as possible. I'm trying to export all of the data between headers from a pivot table into 1 cell but the items in between are inconsistent in terms of their cell creation. I tried the "=CONCATENATE" function however...

Hi everyone, I tried a simple search on forums but no answer to my problem poped up. I got this situation: Got circa 20 workbooks created as output form db sotware, so formatting is exactly the same in all of them. Each workbook conains multiple sheets. I Need output in single workbook, with...

Hi all, Ok, so I have two worksheets(index and master). When the user inputs data, the program creates a unique PR number automatically that has 3 letters, then 5 numbers. (eg. STL39849). I did this by concactenating two other cells. I want to copy and paste this PR number so I can paste it in...

Hi All, So I have to worksheets (History and Flat). I have created a unique PR number in the History sheet using CONCACTENATE. The problem I am now running into is copying this value and pasting it into the Flat sheet. I feel like the solution to this may be fairly simple. I would also like to...

Hi, i have a table with dates on x axis and name along the top. The table is either populated with values or #N/A. For the #N/A cells Im going to have to write a code in access to retireve additional values, however as the table is quite large, 10000+ records, what I wanted to know was could...

hello all, i currently have a macro set to open a webpage, search and return data to a specific cell and add the next result in the next row and then format each result to trim out the first 16 characters, what i'm hoping to do is return the results all in the same cell with each result having...

Dear Potential Helper, I currently have a large database in the following format, where there are some cells that are empty: <tbody> Mr Patel Mr Smith Mrs Smith Mr Lewis Mrs Lewis Mrs Jones Ms Lewis </tbody> What I need to do is create a list of the outputs in the row, so for this row...

I was wondering how to do a vlookup - taking a certain cell's information based on today's date. For example, here is the data: <tbody> 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 </tbody> <tbody>...