Poker
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
21 Jan 10
13:48
Joined:
Date Joined:
04 Jun 04
Been yonks since ive used this so cant remember a thing...
Say you have data in the form
1
MR A Smith
024 111111
101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
2
MR B Smith
024 222222
102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
3
MR C Smith
024 333333
103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
4
MR D Smith
024 444444
104 ANY ADDRESS, Coventry, West Midlands, POSTCODE
5
MR E Smith
024 555555
105 ANY ADDRESS, Coventry, West Midlands, POSTCODE
6
MR F Smith
024 666666
106 ANY ADDRESS, Coventry, West Midlands, POSTCODE
all this appears in A1:A24
The list in column A is lot lot bigger than this but using 6 contacts as an example
[u]QUESTION[/u]
how do i get it so it appears on a new sheet as follows
A1:B1:C1:D1 would be 1,MR A Smith,024 111111,101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
A2:B2:C2:D2 would be 2,MR B Smith,024 222222,102 ANY ADDRESS, Coventry, West Midlands, POSTCODE
ETC ETC
not explained it too well but hope its clear enough...
THANKS IN ADVANCE , SHERRIFF
Say you have data in the form
1
MR A Smith
024 111111
101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
2
MR B Smith
024 222222
102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
3
MR C Smith
024 333333
103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
4
MR D Smith
024 444444
104 ANY ADDRESS, Coventry, West Midlands, POSTCODE
5
MR E Smith
024 555555
105 ANY ADDRESS, Coventry, West Midlands, POSTCODE
6
MR F Smith
024 666666
106 ANY ADDRESS, Coventry, West Midlands, POSTCODE
all this appears in A1:A24
The list in column A is lot lot bigger than this but using 6 contacts as an example
[u]QUESTION[/u]
how do i get it so it appears on a new sheet as follows
A1:B1:C1:D1 would be 1,MR A Smith,024 111111,101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
A2:B2:C2:D2 would be 2,MR B Smith,024 222222,102 ANY ADDRESS, Coventry, West Midlands, POSTCODE
ETC ETC
not explained it too well but hope its clear enough...
THANKS IN ADVANCE , SHERRIFF
Show More
'Text to Columns' is the tool you are looking for should be under the 'Data' header
little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheet
if you have
a1=Sheet6!A1
a2=Sheet6!A6
a3=Sheet6!A11
and i want to carry on this series downwards eg in a4 i would have
=Sheet6!A16 and then A21 etc etc..
how do i drag the formulas downwards or what function do i use in order to maintain the series
my head fried at min
if you have
a1=Sheet6!A1
a2=Sheet6!A6
a3=Sheet6!A11
and i want to carry on this series downwards eg in a4 i would have
=Sheet6!A16 and then A21 etc etc..
how do i drag the formulas downwards or what function do i use in order to maintain the series
my head fried at min
$ signs used i think either side of the constants and the variables left alone and excell should autofill the difference needed
cant seem to get it to do it mandy... im not sure if its index function instead..
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539