format / split address lines in xl

$2-8 AUD / hour

En cours

Publié

il y a presque 9 ans

$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

N° de projet : 7938475

Concernant le projet

6 propositions

Projet à distance

Actif à il y a 9 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@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 en 3 jours

5,0

(32 commentaires)

4,7

6 freelances proposent en moyenne $7 AUD/heure pour ce travail

@TypingxpertRehan

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

$10 AUD en 15 jours

5,0

(552 commentaires)

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 en 6 jours