format / split address lines in xl

$2-8 AUD / hour

Status

Publicerad

nästan nio år sedan

$2-8 AUD / hour

we have approx 350 lines in xl spread sheet that have to be massaged to fit a strict template one cell may contain an address eg below Shop B - 197 Chadstone shopping Centre, 1341 Dandenong Rd CHADSTONE VIC 3148 we need each of these lines split into logical line addresses to fit a template spread sheet line 1 : shop b - 197 Chadstone shopping Centre line 2 : 1341 Dandenong Rd line 3 : Chadstone line 4 : VIC line 5 : 3148 template has rules eg max 30 character length for line1 so we will need some standard words shortened in those case ie shopping center may be shortened to shopping ctr for eg orig address book and template attached

Data Entry

Data Processing

Excel

Project ID: 7938475

Om projektet

6 anbud

Distansprojekt

Senaste aktivitet nio år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@richkumar

Hello, I have experience in excel. I can do this job. Please check my portfolio. I can do this project with accuracy. I am ready to start Now. Please review my bid. Thanks. Rich

$3 AUD Om 3 dagar

5,0

(32 omdömen)

4,7

6 frilansar lägger i genomsnitt anbud på $7 AUD/timme för detta uppdrag

@TypingxpertRehan

so we need to count the characters in each time, its splitting into columns, ok understood, can deliver thanks

$10 AUD Om 15 dagar

5,0

(552 omdömen)

7,8

@Innovative116

Hi there. I am a full time excel expert. Formatting 350 lines of excel in explained will be done within 6 hours. As mentioned, max characters should be 30, then street will St, Road will be Rd, Center will be ctr etc. Please check my past feedbacks for my expertise in similar excel formatting projects done. Ready to start right away. Happy to do sample work before project awarding. Best, Ethan

$8 AUD Om 6 dagar