I have some work, in an Excel spreadsheet.

£10-20 GBP

Sürüyor

İlan edilme:

7 yıldan fazla önce

£10-20 GBP

Teslimde ödenir

This is a very simple task. I need only one code (formula) to do the task in Excel. I will pay £10 for the code straight away. It should be easy. I want a code to flip (swap) two words separated by "/" inside excel cell, without flipping the rest of the words in the cell itself. There is no better way to explain it than the classic Apple vs. Orange debates :) Imagine the excel cell has this sentense: I love eating Apple/Orange fruits everyday The result that I want is this: I love eating Orange/Apple fruits everyday I don't want to completely swap left and right. For example: This is NOT the result I want: Apple fruits everyday/I love eating Orange. I also must keep the "/" between the two swapped words. I don't want these results: I love eating Orange Apple fruits everyday Nor this result (obviously): Apple fruits everyday I love eating Orange To summarise: I want to flip ONLY the first word before "/" with the first word after "/". To put it in another way: The first word on the left of the "/" with the first word on the right of the "/", still separated by "/" without any spaces. The remaining words should stay the same. I don't want you to use character counter (to count how many characters to swap before and after) because I have different words with different lengths. Your formula should consider swapping by WORDS (a word is one continuous set of characters without spaces). If you think you got a working formula for this, please let me know. Best regards, Zed

Coding

Excel

Proje No: 11256421

Proje hakkında

10 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 8 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

10 freelancers are bidding on average £13 GBP for this job

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

£10 GBP 1 gün içinde

4,9

(271 değerlendirme)

7,2

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. This is pretty simple to do. I've done hundreds of excel projects and i've never had a single problem. So if you are interested just pm me and i will help you. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Edit: I have formula ready for you. Simply pm me and i will send it to you. Thanks, Milan

£10 GBP 0 gün içinde

5,0

(388 değerlendirme)

6,7

@ianfosgate23

Will do as instructed and swap the "/" in the strings in your cells in excel. Feel free to message me.

£10 GBP 0 gün içinde

5,0

(133 değerlendirme)

6,4

@bdoutsource

Hi Zed, Greetings. I worked a while on this and found a solution but that is not done in single formula. Had to use 3 steps with three different functions to obtain the result that you are expecting. Plz let me know if that works for you. Thank you. Sincerely, ahmusza

£10 GBP 1 gün içinde

4,8

(96 değerlendirme)

6,0

@vlayausa

Hello, I am proficient with excel and VBA and I can make a macro for this. Please contact me for more information.

£10 GBP 1 gün içinde

4,9

(127 değerlendirme)

5,8

@kahilH

i use java to make simillar manipulations it gives a perfect work you can send me the csv files and i will do the work if you are interested contact me thanks

£13 GBP 1 gün içinde

4,7

(22 değerlendirme)

4,8

@nineoneone

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if you are unsatisfied, due to any reason, with our work. Will accept the lowest amount, you think fair. Please do give me a shot. Awaiting your response. Thanks!

£20 GBP 0 gün içinde

4,9

(14 değerlendirme)

4,3

@nardiM

Hello sir! I have good knowledges on Excel. I know the most suitable tool which allows to flip words that are separated by a specific character like comma, backslash, quotation marks or whatever you need to use. Looking forward to hear from you and hopefully it helps you. Best regards, Leonard!

£19 GBP 1 gün içinde

4,9

(9 değerlendirme)

3,2

@abubakar4248

Hi... i read the descriptions and understand i will provide quality work according to your requirement in given time period i will work on our project until you satisfy i am professionally software engineer(Present) having 2 year experience in this field you can check my portfolio. i will feel confidence to work with you....! Thanks

£13 GBP 1 gün içinde

0,0

(0 değerlendirme)

0,0

@rkgNYC

Hello. I'll just provide this to you now. Paste this into cell B1. It assumes your text is in cell A1. It's an array formula, which requires a special way to enter it: After you paste it, press F2 (to get into formula edit mode), then press Ctrl+Shift+Enter (i.e., hold down Ctrl key and Shift key, then while they're still held down, press Enter). This should put curly braces "{ }" around the formula, and give you your result. If any of your text has multiple slashes "/", this will only flip the first one and leave the rest unchanged. =LEFT(A1,(MAX((MID(A1,ROW(INDIRECT("A1:A"&SEARCH("/",A1))),1)=" ")*ROW(INDIRECT("A1:A"&SEARCH("/",A1))))+1)-1)&MID(A1,SEARCH("/",A1)+1,(SEARCH(" ",A1,SEARCH("/",A1))-1)-SEARCH("/",A1))&"/"&MID(A1,(MAX((MID(A1,ROW(INDIRECT("A1:A"&SEARCH("/",A1))),1)=" ")*ROW(INDIRECT("A1:A"&SEARCH("/",A1))))+1),SEARCH("/",A1)-(MAX((MID(A1,ROW(INDIRECT("A1:A"&SEARCH("/",A1))),1)=" ")*ROW(INDIRECT("A1:A"&SEARCH("/",A1))))+1))&MID(A1,SEARCH(" ",A1,SEARCH("/",A1)),LEN(A1)) If you enjoy this formula, I'd be pleased if you were to select me for this project & make this all real official like. All the best. rkg

£13 GBP 1 gün içinde