First Last Name Exchange

Dec 19, 2007

I have a large employee spreadsheet list with first name then last name in the same cell. Is there a formula that will change the order so it will read last name, first name?

View 9 Replies


ADVERTISEMENT

Exchange Data Between Cells?

Dec 11, 2012

I wanted to exchange data between two cells. i.e if i have mistakenly put one value of A1 in A2 and A2 in A1. How can I exchange it. I am asking this bec by copy paste method one cell is overwritten so the value of that data is lost.

e.g A1 has value 200 but the correct value is 150
A2 has value 150 but the correct value is 200

How can i exchange/swap the values between the two cells..

View 2 Replies View Related

Exchange Text In A Cell

Sep 4, 2013

Is possible exchange text in a cell like this "street San Miguel de Allende-Cp 4780 031 1304" to "street San Miguel de Allende, 1304 -Cp 4780 031". how to do this?

View 3 Replies View Related

Exchange Data Between Workbooks

Dec 14, 2009

Is it possible when i am in my current workbook to refer to the value in another cell in another workbook within a formula?

Example:

I have a workbook named "Sample1.xls" that contains a spreadsheet "revenue" and in cell C24 is the value that i want to have in my current workbook.

View 2 Replies View Related

Change SUMPRODUCT To IF With Exchange Rate

Mar 31, 2009

As you can see in the attached sample file, I have different currencies, that all need to be converted to USD.

The exchange rate are displayed on sheet 2.

Currently the formula just picks all values without considering the exchange rate to USD. What I need to have, is a formula which, based on the currency, picks the correct exchange rate and outputs USD.

Apart from that, another thing the formula should consider is the value of G1 in sheet 2. With G1, the user can later define a specific type to be calculated by simply pressing down the button and chose either FG or RM.

The formula needs to:

Find out what currency the value is in and automatically convert it to USD via the exchange rate values. It also needs to consider the value of G1 in sheet 2 in order to filter out the other values. If, for example G1 is FG, then only FG should be taken into the process and therefore only values where type FG is marked.

View 9 Replies View Related

Exchange A Number For A Letter Forumla

Aug 8, 2009

I have a sheet which calculates payment amounts.

Column titles:
Hours | Rate of Pay | Total

In the hours column usually the entries consist of numbers and everything works fine. However when an employee is on holiday they are still paid.

What I want to do is be able to enter the letter "H" for one of the entries in the hours column. The sheet to translate this as 2 hours.

H=2 x rate of pay = total

I cannot for the life of me get the correct formula to in order to achieve this. I don't particularly want to use a macro for this and others have suggested the "COUNTIF" function.

View 10 Replies View Related

Insert Live Exchange Rate?

Jul 14, 2010

I work with different currencies in my company, now I would to get an up to date state of the cask book. So I have $250, and 500EUR, now I want a formula (connecting to internet) that automatically multiplies the $250 with the current exchange rate, so I know how much I have in Euros in total.

View 5 Replies View Related

Range Value: Change The Exchange Rate

Dec 21, 2009

I have a financial sensitivity sheet setup by year, where for example below each year is a cell you can change the exchange rate in and it effects the outcome of cash flow as these cells are linked to part of the finances. Then I have a "reset" button setup that is assigned to a macro. When you click the reset button all cells in the exchange rate row will be changed to a value that is entered in a "base case" cell. That way various years can be changed but also everything can be set back to the default or base case. My macro for that case is this:

View 5 Replies View Related

How To Keep Track Of Changes In Prices Imported From Exchange

Sep 30, 2013

I work with a broker that have an API function and all the prices goes directly to an Excel Sheet.

What I want is a way to keep track of this prices in a new sheet, as they change. Like a historical price.

Is there any way that excel can do it for me?

View 6 Replies View Related

Aligning Two Series Of Currency Exchange Rates With Different Dates?

Nov 28, 2013

I have two different columns of currency time series data with dates that do not align. One trades Monday-Friday, the other seven days a week.

I want to either a) add dates to the shorter series that only trades Monday - Friday (and just use the closing price on Friday for the Saturday and Sunday dates)

b) (not as good an option, as I will lose data) is delete the Saturday and Sunday data from the longer series that trades on the weekend.

View 1 Replies View Related

USD Equivalent In Column Based On The Exchange Rate At The Time

May 24, 2007

Dates in Column A
Currency in Column B (expressed as EUR, CHF or GBP)
Amount in Column C

And I'm trying to get the USD equivalent in column D based on the exchange rate at the time.

In Sheet 2 I have a table of the historical exchange rates like this:

DateEURGBPCHF
08/05/20060.786270.538151.2277
09/05/20060.784470.536751.2224
10/05/20060.781360.536271.2185
11/05/20060.778050.530761.2108
12/05/20060.775880.528811.2019
15/05/20060.779780.530911.2089

View 9 Replies View Related

Post Spreadsheet To Microsoft Exchange Public Folder

Sep 18, 2006

I'm looking at publishing a number of spreadsheets to the Public Folders section on our local Microsoft Exchange Server.

In Excel I can select File > Send To > Exchange Folder...
but I was wondering if there is a way to automate this in a macro?
I would also like to specify a folder it should be posted?

View 6 Replies View Related

Macro To Access A Website And Copy Exchange Rates

Jan 25, 2007

My task is to somehow access [url] and copy the exchange rates on the table to my Excel workbook. Obviously a macro will not record outside of the Excel program, so I am just wondering if this is possible at all (without hacking of course). My plan B is to have the user manually enter the exchange rates.

View 3 Replies View Related

EXCEL 2013 :: Show Currency Exchange Rate In One Cell

Apr 16, 2014

Is it possible in Excel 2013 to have one cell show current exchange rate of Euro to dollar?

View 1 Replies View Related

Conditional Divide (probs Occur When I Manually Enters The Exchange Rate)

Sep 25, 2007

The file is a simple sheet which upon entering the actual/Invoice cost (C5), calculates the estimated landing/final cost (C8).

In between the process involves changing the currency from US$ to PKR, make some calculations, and changing back the currency again to US$.

The default rate of currency exchange is set to ave 60 (C12). However if the user knows the current rate he can put it manually in C6 and sheet will make all the calcs on this instead of using the default rate.

Problem:
Everything is working just too perfect. But probs occur when i manually enters the exchange rate.

It does successfully changes the US$ to PKR and calculates everything perfectly but doesnt reverts the final cost back to US$ successfully instead it keeps using the default value instead of user's value

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved