Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Remove everything right of the rightmost instance of a character.

Hello,

As the title suggests i am trying to remove everything in a cell right of the rightmost instance of a certain character. All the formulas i've tried so far removes everything right of the left most instance of the character. e.g. something like this

=LEFT(A1,FIND("_",A1)-1)

so this results in 'One_two_three' to equal 'One'

I'm looking for something to result in 'One_two_three' to equal 'One_two'

Or similarly 'One_two_three_four' to equal 'One_two_three'

Any help would be much appreciated.

Thanks
Dom


Post your answer or comment

comments powered by Disqus
Here is a sample file for download: cases.com/test/AdWords-Template.xlsx

My question is... In column A I need to remove everything left of the last "/" including the last "/" as well. Have tried multiple formulas including: The (LEN), (SUBSTITUTE), (REPLACE) and (FIND) function. Can't seem to get this one solved. Your help is much appreciated.

Thank You,
Guy Pierce

I would like to extract everything to the right of the numbers in a cell that contains both text and numbers (format: text space numbers space text), text to columns doesn't work.

Example: Medical Unit 123456 Registered Nurse
Clinical Unit (3N) 234567 RN

I need to extract "Registered Nurse" and "RN"

Many thanks in advance.

Is this possible if the data string in each cell is not uniform

Michael Maloney /J
Benhammer OddF
Xi Xiang Xu /

in the above example i am wishing to remove the characters in bold, what they have in common is they are the characters to the right of the last space in the string.
Can anyone help me.
Thanks

I'm trying to return the string of text to the right of the LAST instance of "/" in:

"GE/MRL/DC/BILLYBOB/DANDRUFF"

So that the result would be "DANDRUFF"

Anybody know how to get just that last part?

Any help would be appreciated!

I would like to loop through column B in the first sheet of the worksheet I have attached and place a formula in column C directly to the right of the value in column B.

I am guessing this is not too complicated, but I am not too familiar with the syntax involved with making a loop. REIT Portfolio External Holders v_01.xlsm

Hi All,

I havee to seterate all the information to the right of text loctaed in a certain cell. I have worked out how to seperate everything to the left, but can seem to come up with a formulas that will do the same for the right.

In the attached sample, column C has the name seprated from col A. In column B I am trying to seperate everything from the right of "W/E" in col A??

Thanks

Rod

Hi there, I have a column of data which is as follows:

Forename Surname (forename.surname@test.com)

I'd like to be able to select the entire column and remove all characters up to the first ( in each row... note, the majority of the cells have a space at the first character point.

Then, I am guessing it would just be a case of doing an Edit Replace "(" with "nothing" and ")" with "nothing" so as to remove the brackets too and just leave an email address.

Any help / quick hints / tips most gratefully received..

Thanks, Matt

I need to sort a list of numbers (and their values) by the numbers to the
right of the decimal, i.e., the list has numerous values to the left (whole
numbers), but the right have only 4 or 5 and I need these segregated by the
decimals to the right in order to put them in columns. From: 600000.3019
50
600000.3030
125
600000.6000
60
602000.3019
100
602000.3030
25
602000.6000
85
To:
600000.3019 50 600000.3030 125 600000.6000 60
602000.3019 100 602000.3030 25 602000.6000 85

i have all of these media library entries (20K+) exported into excel... but just everything in one column arranged like this:
libraryentry#. artist - album - track# - tracktitle (tracktime)

example
18613. The Shins - Chutes Too Narrow - 01 - Kissing The Lipless (3:19)

is there a formula or series of formulas that could break that up for me piece by piece?

--eg trim the libraryentry# starting w/ the period & going cutting off the left
--then somehow trim everything right of the artist divider (space hyphen space), giving me a column w/ artist
--...& then similarly repeat until i get columns for each piece?

Hello,

I have a worksheet where I have 8000+ rows of data in column A with data like "123456789 for vlan123-gw:12.345.67.89/1234 (12.345.67.89/1234) to vlan123-host:987.65.43.21/98 (987.65.43.21/98)". I need a code that says remove everything outside of the parenthesis. Is that possible? Thanks in advance!

Hi Everyone,

I have searched through past topics, but cannot seem to get this right.
The only VBA programming I have done is through the macro recorder, so
I am not familiar with any technical lingo. Can anyone explain, in
extreme layman's terms, how to to generate a list of all of the files
in a windows folder?

Thanks,

Pat

I have to do a sheet and some of the cell have a red background. For some of
those i have to add some comments. I can not have the comments always on. The
fact the the background is the same color as the small triangle indicating
the presence of a comment (in the upper right corner) makes it invisible. I
have not been able the find the way to change the color of that indicator.
Please let me know how to do it.
Thnaks

I have to do a sheet and some of the cell have a red background. For some of
those i have to add some comments. I can not have the comments always on. The
fact the the background is the same color as the small triangle indicating
the presence of a comment (in the upper right corner) makes it invisible. I
have not been able the find the way to change the color of that indicator.
Please let me know how to do it.
Thnaks

Is there a formula in Excel which will print the day of the week from a date value in an adjacent cell?

For instance, in A1 I have a timestamp value:

"10/2/2011"

...and I'm looking for a formula which will print:

"Sunday"

...in B1.

Thank you, for any help!

In the first tab of a worksheet, I have the weeks and the corresponding month in columns:

Week # Month # days
1 Jan 5
2 Jan 5
3 Jan 5
4 Jan 5
5(1) Jan 2
5(2) Feb 3
6 Feb 5
7 Feb 5
8 Feb 5
9(1) Feb 3
9(2) Mar 2
10 Mar 5
11 Mar 5
12 Mar 5
13 Mar 5
14 Apr 5
15 Apr 5
16 Apr 5
17 Apr 5
18(1) Apr 1
18(2) May 4
19 May 5
20 May 5
21 May 5

In a second tab, I have a profitability analysis by week:

Week 6 7 8 9 10 11 12

Revenue - - - - - - -
Costs - - - - - - -
Margin - - - - - - -

Projects can start at any point, so the first week (6 in the example above) is not always the same.
I want the model to automatically populate the cells to the right of the starting week based on the calendar above. So the last week of Feb should be 9(1) and the first week of march 9(2). What formula can I use?

Hi,

Is it possible to format only part of the text in a Series on a graph? I have a list of projects in the X Axis and I want to bold only certain words. I have attached a screen shot to give you an idea.

My X-Axis pulls in the text names from column M. In this example, I am wondering if there is an option or a way to bold the part that circled in Red. Even if it is manual, that is okay as long as I can do it in Excel and not a program like MS Paint or Snag It.

I have tried bolding the text directly in Column M but that formatting does not carry over. I am using Excel 2003.

Excel Chart question.jpg

Hi
I created a message box with Yes/No/Cancel buttons on it.

MsgBox("Would you like to save this report as a word document?", vbYesNoCancel, "State Review Report")

I'd like to rename the Yes/No/Cancel buttons as Save/Goto Main Menu/ Go to Search Menu

How can I change the names of the buttons on a MsgBox? Or can I creat a MsgBox and name the buttons by myself?

Thanks for the help

bolding part of the text in a string...

i would like to bold only the word "Date:" in the string below:

="Date: " & TEXT(Landbid!B4,"mm/dd/yy")

????

thank you.

Hi

How to set the borders and the alignment of the text in a cell using VBA?

Thanks in advance

If I format a cell to use: d/m/yyyy h:mm can I use the d/m/yyyy to place the name of the day in a seperate cell?

Example: if d/m/yyyy h:mm = 15/08/2004 11:30 is there a method to read 15/08/2004 and Place the value of Sunday in a cell?

Thanks,
John

I have a column of data that contains addresses that must have been exported
from a database, perhaps Outlook. Some of the addresses have a character at
the beginning of the string that I need to remove. It looks like an
apostrophe (') but when I do a Find I come up empty. I was hoping to do a
Find/Replace but no luck. How can I remove this nasty character?!

tks,
steve

Hello,
1st: Thanks in advance.
2nd: I am very new to writing macro's, so please be gentle

I am looking to write an Excel macro that checks the 2 beginning letters of the value in a cell and replaces the value of that cell with a letter.

For example if the cell begins with "82" or "GS" then it gets replaced with "g".

Is this possible? If so please explain it as simply as possiple so i can follow along.

Thanks again.

in vba for access how do i get the day of the week for a date field?

My document is to the far right of the screen, up too far for me to grab the
title bar and use the minimize/maximize buttons. How do I get my document
back to where I can work with it?


No luck finding an answer? You could always try Google.