I am trying to split 700 names with phone numbers. They are in column A.
There are hyphens between the names and phone numbers. Do I have to replace
it with a coma and if so can i do the first one and copy it to do the rest or
do i have to do each one individually. I not really caught on to this posting
yet, so please accept my thanks in advance. Any help is very much appreciated.
ie John Doe - 250-555-5555

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Well earned, well deserved. Congratulations.

"T. Valko" wrote:
Biff
Microsoft Excel MVP

I think I did everything you requested but i get a message " cannot find the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

Another way - select your column - making sure that you have a couple of
empty columns to the right of the one selected. click on "text to columns".
Choose "Delimited", then click on the next button. in the next dialog box,
there is a list of Delimiters on the left. Check the box in front of "other"
and then put in a hyphen. click next, then finish.

"B.W." wrote:


I think I did everything you requested but i get a message " cannot find the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

Thank-you that worked. But I would like to keep my phone number in one column
if possible. I tried to regrouped the two columns with the phone number, but
I am not having any success.

"mfdou" wrote:

Another way - select your column - making sure that you have a couple of
empty columns to the right of the one selected. click on "text to columns".
Choose "Delimited", then click on the next button. in the next dialog box,
there is a list of Delimiters on the left. Check the box in front of "other"
and then put in a hyphen. click next, then finish.

"B.W." wrote:


I think I did everything you requested but i get a message " cannot find the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

Thank you, Max.

Hopefully, I haven't lowered the standard!

Biff
Microsoft Excel MVP

"Max" wrote in message
...
Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks, Jerry!

Biff
Microsoft Excel MVP

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Well earned, well deserved. Congratulations.

"T. Valko" wrote:
Biff
Microsoft Excel MVP

B.W. wrote:
Thank-you that worked. But I would like to keep my phone number in one column
if possible. I tried to regrouped the two columns with the phone number, but
I am not having any success.

"mfdou" wrote:

Another way - select your column - making sure that you have a couple of
empty columns to the right of the one selected. click on "text to columns".
Choose "Delimited", then click on the next button. in the next dialog box,
there is a list of Delimiters on the left. Check the box in front of "other"
and then put in a hyphen. click next, then finish.

"B.W." wrote:

I think I did everything you requested but i get a message " cannot find the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555



Assuming you still have an original try using text to columns and
leaving it as fixed width you can then place your dividers where you
need them. If you place the dash between the name and phone number in
it's own column you can just mark it not to import or just delete it later.

gls858

Ok, it might be that those spaces are not standard char 32 spaces. They
might be char 160 non breaking spaces. In the EditReplace operation:

Find what: hold down the ALT key and using the *numeric keypad* type 0160
let up on the ALT key then type the dash then hold down the ALT key and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message " cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

"gls858" wrote in message
...
B.W. wrote:
Thank-you that worked. But I would like to keep my phone number in one
column if possible. I tried to regrouped the two columns with the phone
number, but I am not having any success. "mfdou" wrote:

Another way - select your column - making sure that you have a couple of
empty columns to the right of the one selected. click on "text to
columns". Choose "Delimited", then click on the next button. in the next
dialog box, there is a list of Delimiters on the left. Check the box in
front of "other" and then put in a hyphen. click next, then finish.

"B.W." wrote:

I think I did everything you requested but i get a message " cannot
find the data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555



Assuming you still have an original try using text to columns and leaving
it as fixed width you can then place your dividers where you need them. If
you place the dash between the name and phone number in it's own column
you can just mark it not to import or just delete it later.

gls858

Assuming that they have a list, not just a single cell.

That would work *if* all the names were the same length. Won't work if you
have:

John Doe - 250-555-5555
William Johnston - 412-555-1212

Biff
Microsoft Excel MVP

T. Valko wrote:
"gls858" wrote in message
...
B.W. wrote:
Thank-you that worked. But I would like to keep my phone number in one
column if possible. I tried to regrouped the two columns with the phone
number, but I am not having any success. "mfdou" wrote:

Another way - select your column - making sure that you have a couple of
empty columns to the right of the one selected. click on "text to
columns". Choose "Delimited", then click on the next button. in the next
dialog box, there is a list of Delimiters on the left. Check the box in
front of "other" and then put in a hyphen. click next, then finish.

"B.W." wrote:

I think I did everything you requested but i get a message " cannot
find the data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

Assuming you still have an original try using text to columns and leaving
it as fixed width you can then place your dividers where you need them. If
you place the dash between the name and phone number in it's own column
you can just mark it not to import or just delete it later.

gls858

Assuming that they have a list, not just a single cell.

That would work *if* all the names were the same length. Won't work if you
have:

John Doe - 250-555-5555
William Johnston - 412-555-1212

Biff
Microsoft Excel MVP



You're right. Sorry about that. I did exactly as you indicated I tested
on one cell. Almost all the files I bring into Excel are fixed length
flat files. I knew better just forgot for the moment :-)

gls858

If using the hyphen as the deliminator separates the two parts of your phone
numbers, you can put them back together fairly easily. make sure there is an
empty column to the right of the two columns with the phone number and enter
=(cell&€�-€œ&cell) in the first cell of the empty column - for instance,
=(A1&"-"&B1) This will give you back your phone numbers with the hyphen.
"T. Valko" wrote:

Ok, it might be that those spaces are not standard char 32 spaces. They
might be char 160 non breaking spaces. In the EditReplace operation:

Find what: hold down the ALT key and using the *numeric keypad* type 0160
let up on the ALT key then type the dash then hold down the ALT key and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message " cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

for the 3 part phone number, just expand the formula
=(A1&"-"&B1&"-"&C1)

"mfdou" wrote:


If using the hyphen as the deliminator separates the two parts of your phone
numbers, you can put them back together fairly easily. make sure there is an
empty column to the right of the two columns with the phone number and enter
=(cell&€�-€œ&cell) in the first cell of the empty column - for instance,
=(A1&"-"&B1) This will give you back your phone numbers with the hyphen.
"T. Valko" wrote:

Ok, it might be that those spaces are not standard char 32 spaces. They
might be char 160 non breaking spaces. In the EditReplace operation:

Find what: hold down the ALT key and using the *numeric keypad* type 0160
let up on the ALT key then type the dash then hold down the ALT key and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message " cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

I forgot to mention - you have to then copy the formula by clicking in the
cell with the formula in it, then move the mouse over the lower right corner
until the cursor turns into a solid black cross, then click and drag the
formula all the way down to the bottom of your list.

"mfdou" wrote:


If using the hyphen as the deliminator separates the two parts of your phone
numbers, you can put them back together fairly easily. make sure there is an
empty column to the right of the two columns with the phone number and enter
=(cell&€�-€œ&cell) in the first cell of the empty column - for instance,
=(A1&"-"&B1) This will give you back your phone numbers with the hyphen.
"T. Valko" wrote:

Ok, it might be that those spaces are not standard char 32 spaces. They
might be char 160 non breaking spaces. In the EditReplace operation:

Find what: hold down the ALT key and using the *numeric keypad* type 0160
let up on the ALT key then type the dash then hold down the ALT key and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message " cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

I think that's a common feeling for everyone--that and the "did you really mean
me?" that goes with it <vbg.

Congrats!

"T. Valko" wrote:

Thank you, Max.

Hopefully, I haven't lowered the standard!

Biff
Microsoft Excel MVP

"Max" wrote in message
...
Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson

Thanks, Dave.

You're still the man!

Biff
Microsoft Excel MVP

"Dave Peterson" wrote in message
...
I think that's a common feeling for everyone--that and the "did you really
mean
me?" that goes with it <vbg.

Congrats!

"T. Valko" wrote:

Thank you, Max.

Hopefully, I haven't lowered the standard!

Biff
Microsoft Excel MVP

"Max" wrote in message
...
Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson

Thank-you, I have both parts together. I would like to delete the the
columns in which they are separate, without affecting the finished product.
Is this possible.
BW
"mfdou" wrote:

I forgot to mention - you have to then copy the formula by clicking in the
cell with the formula in it, then move the mouse over the lower right corner
until the cursor turns into a solid black cross, then click and drag the
formula all the way down to the bottom of your list.

"mfdou" wrote:


If using the hyphen as the deliminator separates the two parts of your phone
numbers, you can put them back together fairly easily. make sure there is an
empty column to the right of the two columns with the phone number and enter
=(cell&€�-€œ&cell) in the first cell of the empty column - for instance,
=(A1&"-"&B1) This will give you back your phone numbers with the hyphen.
"T. Valko" wrote:

Ok, it might be that those spaces are not standard char 32 spaces. They
might be char 160 non breaking spaces. In the EditReplace operation:

Find what: hold down the ALT key and using the *numeric keypad* type 0160
let up on the ALT key then type the dash then hold down the ALT key and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message " cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

Add my congrats to this thread Biff.

Welcome aboard.

A few months ago you posted that becoming an MVP was your goal so what's your
next goal?


Gord

On Mon, 02 Jul 2007 13:41:44 -0500, Dave Peterson
wrote:

I think that's a common feeling for everyone--that and the "did you really mean
me?" that goes with it <vbg.

Congrats!

"T. Valko" wrote:

Thank you, Max.

Hopefully, I haven't lowered the standard!

Biff
Microsoft Excel MVP

"Max" wrote in message
...
Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hi Biff

Congratulations, very well deserved.
I am also very happy to be joining you, and hope I can live up to
expectations!!!

--
Regards

Roger Govier


"T. Valko" wrote in message
...
Thanks, Dave.

You're still the man!

Biff
Microsoft Excel MVP

"Dave Peterson" wrote in message
...
I think that's a common feeling for everyone--that and the "did you
really mean
me?" that goes with it <vbg.

Congrats!

"T. Valko" wrote:

Thank you, Max.

Hopefully, I haven't lowered the standard!

Biff
Microsoft Excel MVP

"Max" wrote in message
...
Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson

I am also very happy to be joining you, and hope I can live up to
expectations!!!

Hey Roger, subtle comment, but I didn't miss that ...
My congratulations to you too! Cheers

P/s: Is there a reference namelist of the new kids on the MVP-Excel block
available ? Or, could someone kindly take a moment to list these new kids?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

There's a privacy issue at work here. So I don't think you'll be seeing a list
posted.

But for those who choose to share, you can check:
https://mvp.support.microsoft.com/communities/mvp.aspx
or for excel:
https://mvp.support.microsoft.com/co...Office+Exc el


Max wrote:

I am also very happy to be joining you, and hope I can live up to
expectations!!!

Hey Roger, subtle comment, but I didn't miss that ...
My congratulations to you too! Cheers

P/s: Is there a reference namelist of the new kids on the MVP-Excel block
available ? Or, could someone kindly take a moment to list these new kids?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson

Thanks Max.

Dave has given the reason for the lack of a list.
I have not got round to setting up a Profile on the website yet, neither
would I imagine have many other of the "newbie's" .

--
Regards

Roger Govier


"Max" wrote in message
...
I am also very happy to be joining you, and hope I can live up to
expectations!!!

Hey Roger, subtle comment, but I didn't miss that ...
My congratulations to you too! Cheers

P/s: Is there a reference namelist of the new kids on the MVP-Excel
block available ? Or, could someone kindly take a moment to list these
new kids?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Select your finished product, copy then click Edit/Paste Special/Values to
convert the formulae to constants. Then delete the other columns you don't
need (verify the paste special works before deleting the source).

I also wanted to jump in and congratulate Biff and Roger on reaching their
goals - very well deserved recognition!


"B.W." wrote:


Thank-you, I have both parts together. I would like to delete the the
columns in which they are separate, without affecting the finished product.
Is this possible.
BW
"mfdou" wrote:

I forgot to mention - you have to then copy the formula by clicking in the
cell with the formula in it, then move the mouse over the lower right corner
until the cursor turns into a solid black cross, then click and drag the
formula all the way down to the bottom of your list.

"mfdou" wrote:


If using the hyphen as the deliminator separates the two parts of your phone
numbers, you can put them back together fairly easily. make sure there is an
empty column to the right of the two columns with the phone number and enter
=(cell&€�-€œ&cell) in the first cell of the empty column - for instance,
=(A1&"-"&B1) This will give you back your phone numbers with the hyphen.
"T. Valko" wrote:

Ok, it might be that those spaces are not standard char 32 spaces. They
might be char 160 non breaking spaces. In the EditReplace operation:

Find what: hold down the ALT key and using the *numeric keypad* type 0160
let up on the ALT key then type the dash then hold down the ALT key and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message " cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555

Dave has given the reason for the lack of a list.
dang! <g no choice, then. looks like I'll have to read deep into all
postings by the regulars to "gather" such info.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger Govier" wrote in message
...
Thanks Max.

Dave has given the reason for the lack of a list.
I have not got round to setting up a Profile on the website yet, neither
would I imagine have many other of the "newbie's" .

Thanks, Gord!

A few months ago you posted that becoming an MVP
was your goal so what's your next goal?

To not embarrass myself as a MVP!
--
Biff
Microsoft Excel MVP


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Add my congrats to this thread Biff.

Welcome aboard.

A few months ago you posted that becoming an MVP was your goal so what's
your
next goal?


Gord

On Mon, 02 Jul 2007 13:41:44 -0500, Dave Peterson

wrote:

I think that's a common feeling for everyone--that and the "did you really
mean
me?" that goes with it <vbg.

Congrats!

"T. Valko" wrote:

Thank you, Max.

Hopefully, I haven't lowered the standard!

Biff
Microsoft Excel MVP

"Max" wrote in message
...
Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Dave, thanks for response/links
.. So I don't think you'll be seeing a list posted.
No choice, resigned to this then. disappointed, though, that such occasions
for us to rejoice/celebrate with new Excel MVPs should be stifled by privacy
issues ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
There's a privacy issue at work here. So I don't think you'll be seeing a
list
posted.

But for those who choose to share, you can check:
https://mvp.support.microsoft.com/communities/mvp.aspx
or for excel:
https://mvp.support.microsoft.com/co...Office+Exc el

Congratulations, Roger!

I had assumed that you were already A MVP but just didn't make it public.

hope I can live up to expectations!!!

Yeah, I know what you mean. Harlan has already "tested" me. I guess I
passed!

Wooo hooo!

<VBG

--
Biff
Microsoft Excel MVP


"Roger Govier" wrote in message
...
Hi Biff

Congratulations, very well deserved.
I am also very happy to be joining you, and hope I can live up to
expectations!!!

--
Regards

Roger Govier


"T. Valko" wrote in message
...
Thanks, Dave.

You're still the man!

Biff
Microsoft Excel MVP

"Dave Peterson" wrote in message
...
I think that's a common feeling for everyone--that and the "did you
really mean
me?" that goes with it <vbg.

Congrats!

"T. Valko" wrote:

Thank you, Max.

Hopefully, I haven't lowered the standard!

Biff
Microsoft Excel MVP

"Max" wrote in message
...
Biff
Microsoft Excel MVP

Congratulations, Biff ! Cheers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson

I'm having trouble figuring out just how to do that?

--
Biff
Microsoft Excel MVP


"Roger Govier" wrote in message
...
Thanks Max.

Dave has given the reason for the lack of a list.
I have not got round to setting up a Profile on the website yet, neither
would I imagine have many other of the "newbie's" .

--
Regards

Roger Govier


"Max" wrote in message
...
I am also very happy to be joining you, and hope I can live up to
expectations!!!

Hey Roger, subtle comment, but I didn't miss that ...
My congratulations to you too! Cheers

P/s: Is there a reference namelist of the new kids on the MVP-Excel block
available ? Or, could someone kindly take a moment to list these new
kids?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks, J!

--
Biff
Microsoft Excel MVP


"JMB" wrote in message
...
Select your finished product, copy then click Edit/Paste Special/Values to
convert the formulae to constants. Then delete the other columns you
don't
need (verify the paste special works before deleting the source).

I also wanted to jump in and congratulate Biff and Roger on reaching their
goals - very well deserved recognition!


"B.W." wrote:


Thank-you, I have both parts together. I would like to delete the the
columns in which they are separate, without affecting the finished
product.
Is this possible.
BW
"mfdou" wrote:

I forgot to mention - you have to then copy the formula by clicking in
the
cell with the formula in it, then move the mouse over the lower right
corner
until the cursor turns into a solid black cross, then click and drag
the
formula all the way down to the bottom of your list.

"mfdou" wrote:


If using the hyphen as the deliminator separates the two parts of
your phone
numbers, you can put them back together fairly easily. make sure
there is an
empty column to the right of the two columns with the phone number
and enter
=(cell&"-"&cell) in the first cell of the empty column - for
instance,
=(A1&"-"&B1) This will give you back your phone numbers with the
hyphen.
"T. Valko" wrote:

Ok, it might be that those spaces are not standard char 32 spaces.
They
might be char 160 non breaking spaces. In the EditReplace
operation:

Find what: hold down the ALT key and using the *numeric keypad*
type 0160
let up on the ALT key then type the dash then hold down the ALT key
and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message "
cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: <space-<space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are
in
column
A.
There are hyphens between the names and phone numbers. Do I
have to
replace
it with a coma and if so can i do the first one and copy it to
do the
rest
or
do i have to do each one individually. I not really caught on
to this
posting
yet, so please accept my thanks in advance. Any help is very
much
appreciated.
ie John Doe - 250-555-5555

Not a realistic goal.

Try something else like "To not embarrass myself as a MVP!.......too often"<g

Gord

On Mon, 2 Jul 2007 21:26:40 -0400, "T. Valko" wrote:

Thanks, Gord!

A few months ago you posted that becoming an MVP
was your goal so what's your next goal?

My congratulations also. Well deserved. There'll be a newcomer's meeting
soon (another privacy thing) which you may have already received notice about
- be sure and set that account up so you can attend.

"Roger Govier" wrote:

Thanks Max.

Dave has given the reason for the lack of a list.
I have not got round to setting up a Profile on the website yet, neither
would I imagine have many other of the "newbie's" .

--
Regards

Roger Govier


"Max" wrote in message
...
I am also very happy to be joining you, and hope I can live up to
expectations!!!

Hey Roger, subtle comment, but I didn't miss that ...
My congratulations to you too! Cheers

P/s: Is there a reference namelist of the new kids on the MVP-Excel
block available ? Or, could someone kindly take a moment to list these
new kids?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---