I've got dozens of cells where I need to remove the apostrophe and the '-' in the cell in order to make the data compatible with another system.
Eg if the cell A1 had the text
I'd want to use a formula in B1 that removes the apostrophe and the dash.
Back before my time, a program that was written that we no longer have access to the source code wrote dates for some cells with a double slash such as 12//01/2018. I have to go through multiple worksheets in the workbook and manually replace these after the application completes its run...
I have a complicated string where I need to remove leading zero from partial string and change the string with different formatting. Example below:
02-01-22 [G MM]
3-05-01 [X SM]
07-6-10 [E SM]
I have tried using NumberValue but...
Hello. I have my column A in Excel like this:
And I want my column B like this(so I want to remove two first and two last characters from column A using one formula):
I have values like this in the cell E6
I want these values in separate rows on F column, what should be the formula ?
I have a cells that contain Names and Dashes ex: "Aaron Arbogust -- John SMith -- Bret Johnson -- Dan Bologna"
I would like that to extract all Upper case letters and Dashes to read:"AA--JSM--BJ--DB"
Basically extract Uppers and Dashes OR remove Lowercase letters and spaces
I have a huge list of Names which includes first, middle, last names and along with their titles, education etc.,
Tina DeRubeis van Zyl
Rebecca Hodson, CPA, MST
David P. Kraus, Jr.
Heather Findon, CPA
James C. Lawson, JD, CPA, MST
Bruce Feinstein, C.P.A...
I'm trying to remove a specific character ")" however, I need it to fit within my existing formula if at all possible. The formula already identifies "(" and removes the character plus everything left of it. I know that the substitute function is probably best here (either that...
This is what I have:
000901000017 00068794 0 CA
000901000024 00014544 0 CA
000901000079 00068796 0 CA
000901002004 00050853 0 CA
Hi...looking for a formula to remove an "= sign" at the very beginning. hence if "=Jordan" then want to change it to "Jordan" in cell T3 only.
but wait, the resulting cell T3 "=Jordan" already has a formula inside it =(U3&V3&W3&X3&Y3)
How to enter formula for removing "= sign" and not...