ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   List in Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/197547-list-excel-2000-a.html)

Dendy

List in Excel 2000
 
I need to be able to convert the following information into an excel
spreadsheet . I would like for the information to go across the paga. I am
not familiar with programing and would like something easier than copy,
paste special and transpose. If I need to use the programing way, please
give me step by step instructions or a place to look it up.

Thank you
Linda Dendy
205-841-2645


Maurine Allen
7475 Skillman St #D-103
Dallas TX USA 75231
Achieva International

(214) 823-9500
(214) 823-9514
Meeting Management Professional
Melissa Allen
3220 Coolidge Highway
Berkley MI USA 48072
Mission Point Resort

248-291-8871
248-542-3868
Supplier Meeting Professional
Micah Allen
105 E. Pascagoula St., Suite 2
Jackson MS USA 39207
Jackson Convention Complex/SMG

601-383-4454
Supplier Meeting Professional
Micki Allen
345 Renfrew Dr #101
Markham ON CAN L3R 9S9
MARAC Enterprises

(905) 474-9118
(905) 474-1968
Corporate Meeting Professional


Pete_UK

List in Excel 2000
 
You've already had two replies to your earlier posting pointing out
how difficult this will be, because you do not have a regular number
of rows per record, and there is no field that clearly marks the end
of one record or the beginning of another. I can't easily identify
the records - you appear to have 4 rows followed by an email address
followed by up to 2 phone numbers and then a job title in the sample
you have posted, but how representative is that sample? Your phone
numbers seem to be formatted in different ways, as well. All of these
things will make it difficult for someone to propose a solution that
will work for you.

Pete

On Aug 5, 12:09*am, Dendy wrote:
I need to be able to convert the following information into an excel
spreadsheet . I would like for the information to go across the paga. * I am
not familiar with programing *and would like something easier than copy,
paste special and transpose. *If I need to use the programing way, please
give me step by step instructions or a place to look it up.

Thank you
Linda Dendy
205-841-2645

Maurine Allen
7475 Skillman St #D-103
Dallas TX USA 75231
Achieva International

(214) 823-9500
(214) 823-9514
Meeting Management Professional
Melissa Allen
3220 Coolidge Highway
Berkley MI USA 48072
Mission Point Resort

248-291-8871
248-542-3868
Supplier Meeting Professional
Micah Allen
105 E. Pascagoula St., Suite 2
Jackson MS USA 39207
Jackson Convention Complex/SMG

601-383-4454
Supplier Meeting Professional
Micki Allen
345 Renfrew Dr #101
Markham ON CAN L3R 9S9
MARAC Enterprises

(905) 474-9118
(905) 474-1968
Corporate Meeting Professional



Dendy

List in Excel 2000
 
I did make to postings and I am sorrry that was an error.

Thank you for your advise.

Linda

"Pete_UK" wrote:

You've already had two replies to your earlier posting pointing out
how difficult this will be, because you do not have a regular number
of rows per record, and there is no field that clearly marks the end
of one record or the beginning of another. I can't easily identify
the records - you appear to have 4 rows followed by an email address
followed by up to 2 phone numbers and then a job title in the sample
you have posted, but how representative is that sample? Your phone
numbers seem to be formatted in different ways, as well. All of these
things will make it difficult for someone to propose a solution that
will work for you.

Pete

On Aug 5, 12:09 am, Dendy wrote:
I need to be able to convert the following information into an excel
spreadsheet . I would like for the information to go across the paga. I am
not familiar with programing and would like something easier than copy,
paste special and transpose. If I need to use the programing way, please
give me step by step instructions or a place to look it up.

Thank you
Linda Dendy
205-841-2645

Maurine Allen
7475 Skillman St #D-103
Dallas TX USA 75231
Achieva International

(214) 823-9500
(214) 823-9514
Meeting Management Professional
Melissa Allen
3220 Coolidge Highway
Berkley MI USA 48072
Mission Point Resort

248-291-8871
248-542-3868
Supplier Meeting Professional
Micah Allen
105 E. Pascagoula St., Suite 2
Jackson MS USA 39207
Jackson Convention Complex/SMG

601-383-4454
Supplier Meeting Professional
Micki Allen
345 Renfrew Dr #101
Markham ON CAN L3R 9S9
MARAC Enterprises

(905) 474-9118
(905) 474-1968
Corporate Meeting Professional




Rick Rothstein \(MVP - VB\)[_1030_]

List in Excel 2000
 
Can you go back to your originally posted message and answer the questions I
asked you there?

Rick


"Dendy" wrote in message
...
I did make to postings and I am sorrry that was an error.

Thank you for your advise.

Linda

"Pete_UK" wrote:

You've already had two replies to your earlier posting pointing out
how difficult this will be, because you do not have a regular number
of rows per record, and there is no field that clearly marks the end
of one record or the beginning of another. I can't easily identify
the records - you appear to have 4 rows followed by an email address
followed by up to 2 phone numbers and then a job title in the sample
you have posted, but how representative is that sample? Your phone
numbers seem to be formatted in different ways, as well. All of these
things will make it difficult for someone to propose a solution that
will work for you.

Pete

On Aug 5, 12:09 am, Dendy wrote:
I need to be able to convert the following information into an excel
spreadsheet . I would like for the information to go across the paga.
I am
not familiar with programing and would like something easier than
copy,
paste special and transpose. If I need to use the programing way,
please
give me step by step instructions or a place to look it up.

Thank you
Linda Dendy
205-841-2645

Maurine Allen
7475 Skillman St #D-103
Dallas TX USA 75231
Achieva International

(214) 823-9500
(214) 823-9514
Meeting Management Professional
Melissa Allen
3220 Coolidge Highway
Berkley MI USA 48072
Mission Point Resort

248-291-8871
248-542-3868
Supplier Meeting Professional
Micah Allen
105 E. Pascagoula St., Suite 2
Jackson MS USA 39207
Jackson Convention Complex/SMG

601-383-4454
Supplier Meeting Professional
Micki Allen
345 Renfrew Dr #101
Markham ON CAN L3R 9S9
MARAC Enterprises

(905) 474-9118
(905) 474-1968
Corporate Meeting Professional






All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com