If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Text to columns
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 |
#22
|
|||
|
|||
Text to columns
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 --- |
#23
|
|||
|
|||
Text to columns
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 |
#24
|
|||
|
|||
Text to columns
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 --- |
#25
|
|||
|
|||
Text to columns
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 |
#26
|
|||
|
|||
Text to columns
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" . |
#27
|
|||
|
|||
Text to columns
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 --- |
#28
|
|||
|
|||
Text to columns
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 |
#29
|
|||
|
|||
Text to columns
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 |
#30
|
|||
|
|||
Text to columns
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 --- |
Thread Tools | |
Display Modes | |
|
|