Using Text to column function

$2-8 AUD / hour

Cancelado

Publicado

há mais de 5 anos

$2-8 AUD / hour

Hello. I have an issue with open office, please see the attached spreadsheet. As you can see, the boxes that are highlighted I would like those 2 numbers separated and put into the next cell over. Example, Under the FG tab in K10 there are 2 numbers which appear as 29-70. I would like the 29 to stay in K10 and the 70 to move to L10. For all of the highlighted boxes to move over into the next cell as described. I copy and paste them into the cell in that format, so I would like to have those cells set up automatically to do so.

ID do Projeto: 17868337

Sobre o projeto

20 propostas

Projeto remoto

Ativo há 6 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

20 freelancers estão ofertando em média $5 AUD/hora for esse trabalho

@haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro etc. thanks

$10 AUD em 2 dias

4,9

(15 avaliações)

3,6

@dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$4 AUD em 40 dias

5,0

(2 avaliações)

1,4

@viswakarmaya

I have finished excel sheet. I shall submit the excel sheet immediately after awarding the project. Proficient and expert in excel and data entry

$8 AUD em 1 dia

5,0

(3 avaliações)

1,2

@thoduc10

chuyện sao chép nay tôi có thể làm tốt và tối sẻ cống gằng hoàn thành công việc trong thời gian nhanh nhất

$3 AUD em 40 dias

0,0

(0 avaliações)

0,0

@msutanana

First, allow me to introduce my self. My Name is M Sutan Arif, my nickname is Sutan. I am from Bogor City, Indonesia. I am 18 years old While I am in High School. I got 8 on Office exam Thankyou Miss.

$3 AUD em 10 dias

0,0

(0 avaliações)

0,0

@akshayprasad999

Typing speed 45 in english Excel knowing

$5 AUD em 10 dias

0,0

(0 avaliações)

0,0

@boopathiraja1154

If you want I can share the formula or myself will do it and share the file. I have experience in this while working in technical support.

$3 AUD em 40 dias

0,0

(0 avaliações)

0,0

@Mb08490

Respected Client, Don't worry it just a easy task and I will do it for you.I will ensure as well that this type of errors of formulas not appear again. Thanks..

$2 AUD em 40 dias

0,0

(0 avaliações)

0,0

@NgunoZ

I can sort all your current and future problems with your spreadsheets using the minimum time possible

$4 AUD em 20 dias

0,0

(0 avaliações)

0,0

@GKEvans

Hello, I could write you a macro which takes any cells that you highlight and splits any contents with a hyphen, with the left side remaining where it is and the right side moving to the adjacent column. Regards, Grainne

$8 AUD em 1 dia