remove

Hello, For the sentence: "A map is a visual representation . The work of a map is to illustrate geography." I know that the formula "=RIGHT(B2,LEN(B2)-FIND(" ",B2))" will remove the first letter in the string. Leaving "map is a visual representation . The work of a map is to illustrate...

Hi My excel has a column like this one: Telmisartan Zentiva MG, 80mg*30 Acetylsalicylic acid Teva MG, 100mg*30 Zolpidem Bayer MG, 10mg*30 ... I need to remove the "MG" and the first word before the "MG", like this: Telmisartan, 80mg*30 Acetylsalicylic acid, 100mg*30 Zolpidem, 10mg*30 Is...

what's the vba code to remove any character after the last "" in a string?

When I open a workbook, it asks to connect to links. Is it possible to remove them and just leave the values in? Thanks

One of my worksheets stops at column "Z" and there's nothing to the right of it. How did I do this ? Can't remember and can't find how from Google. Thanks.

Hello: The following codes finds the last row in a table and then creates a simple numerical index starting with 1. A couple of things: ==> Is there a way to refer to column C without hard coding it so I can add and remove columns without a problem? ==> Is there a way to refer to cell C7...

Hi All, I have 1 column with a series of numbers that has 6 digits then 2 spaces and then 4 to 5 digits. i am trying to remove both spaces. I am able to remove 1 space with TRIM but I need to remove the 2nd space. My co-worker has a concatenate that has no spaces and can't add spaces to their...

Hi Guys, I'm trying to remove the blanks from an adjacent column as per the table below. Any ideas from you wonderful people? <tbody> Data 1 Data 2 Result 1 Cat Cat Dog Chicken 1 Chicken Sheep Cat Apple 1 Sheep 1 Apple Banana </tbody> Thanks!!!

Dear all, I need to combine 300 words in a column (separate cells) in to 30 words in single cell each. I will have to do it many more times.... I use the forumula =concatenate(transpose(INDEX(A1:A1000,30*(row()-1)+1):INDEX(A1:A1000,30*(row()-1)+30))&" ") and drag it down. Problem is I have to...

I have a single DatePicker control that sets all my dates on my spreadsheet. How do I remove the "drop down check box" when I print. I don't see any controls to do that like in Access. Thanks for the help.

I have the following formula in the cells in column S is =IF(Key!AY:AY="NotExist", Key!AZ:AZ,""). I want to remove the blanks and display just these numbers at the top of column S. Column S <tbody> 4500429658 4500429343 4500429117 4500434998 </tbody>

Hi need help with excel spreadsheet which has my header 2 blank rows row of data then 2 blank rows row of data and this carries on all the way down is there anyway I can remove the blank rows please

Hi all I have list of details have dots at the end I want formula to remove all please help me in this. <colgroup><col width="153" style="width: 115pt; mso-width-source: userset; mso-width-alt: 5595;"> <tbody> Match Type . . . . . . Address Number ( # ) . Mailing Name . . . ...

I had password protection added to a workbook so other viewers could not make changes. I removed the protection and re-saved some of the worksheets. Although a password isn't required to open any of the re-saved worksheets, a pop-up appears on opening advising the user that selecting Yes will...

I have a flow of .html files that needs two processes don Remove all rows in column C the contain a value less than -3 and greater than 3 Remove all rows containing the at of the following: COND TOP D-LINE T-LINE SER-LINE I am completely new to macros and virtual basic. Please...

Hello I have a big data file in excel with some 'weird' numbers for example: <tbody> 4959,68,4611,9 </tbody> Sometimes it's like this: 7500,7152,22 How can i remove the last commas so that only the first comma will stay? Thanks in advance Regards Wout ****** id="cke_pastebin"...

Hi there, A question about optimizing sheets from colleagues and exterior firms. I've read a bit on best practices and rules of good tables to increase user-friendliness and reduce the reader's cognitive load. As a practice, I'd like to improve and automate the following example. The following...

Can someone help with code that will look down range B1:B50 and when a minus sum is found, delete that cell and the adjacent value in column A, then remove those blank cells. Not remove entire row - just blank cells in columns A:B example Test 1 200 Test 2 -300 Test 3 1345...

Hi all, I've got a macro which appeared to be working perfectly, however when I ran the data without any of the products to be excluded I found that I was losing EVERYTHING :confused: I've narrowed the culprit down to this: 'Remove excluded products Sheets("Consolidated").Select...

Hey all. I've found where other people have had this error but those solutions haven't helped me solve this one. Long story short I built this for another employee about a year ago and my memory is fuzzy on some specifics. There's only one PivotTable on the sheet. I get the typical error...