LinkBack Thread Tools Search this Thread Display Modes
  #31   Report Post  
Old July 3rd 07, 02:38 AM posted to microsoft.public.excel.newusers
external usenet poster
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Text to columns

Thanks, J!

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
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
Is this possible.
"mfdou" wrote:

I forgot to mention - you have to then copy the formula by clicking in
cell with the formula in it, then move the mouse over the lower right
until the cursor turns into a solid black cross, then click and drag
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
=(A1&"-"&B1) This will give you back your phone numbers with the
"T. Valko" wrote:

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

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
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All

Then do the text to columns

Microsoft Excel MVP

"B.W." wrote in message

I think I did everything you requested but i get a message "
cannot find
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

With those cells still selected
Goto the menu DataText to Columns

Microsoft Excel MVP

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

  #32   Report Post  
Old July 3rd 07, 03:13 AM posted to microsoft.public.excel.newusers
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Text to columns

Not a realistic goal.

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


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?

  #33   Report Post  
Old July 4th 07, 02:46 AM posted to microsoft.public.excel.newusers
external usenet poster
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,365
Default Text to columns

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" .


Roger Govier

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

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?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Text from 2 Columns into 1 then Deleting the 2 Columns sleepindogg Excel Worksheet Functions 5 September 19th 08 12:36 AM
help with sorting text in columns to match other columns rkat Excel Discussion (Misc queries) 1 August 11th 06 03:42 AM
merge text from 2 columns into 1 then delete the old 2 columns sleepindogg Excel Worksheet Functions 4 March 30th 06 07:25 PM
Excel is automatically doing "text to columns" upon paste text. robert10000 Excel Discussion (Misc queries) 1 June 15th 05 07:49 PM
Linking text columns with text and data columns Edd Excel Worksheet Functions 0 March 17th 05 04:23 PM

All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017