|
|
|
|
 |
October 24th, 2002, 11:36 PM
|
 |
National Security Advisor
|
|
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 4 Times in 1 Post
|
|
Re: M$ Excel
=CONCATENATE(A1," ",B1," ",C1," ",D1)
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
|
October 25th, 2002, 12:51 AM
|
 |
Shrapnel Fanatic
|
|
Join Date: Jul 2001
Location: Southern CA, USA
Posts: 18,394
Thanks: 0
Thanked 12 Times in 10 Posts
|
|
Re: M$ Excel
Ok, thanks!
|
October 25th, 2002, 05:28 PM
|
 |
Major
|
|
Join Date: Oct 2000
Location: New York, NY
Posts: 1,066
Thanks: 1
Thanked 1 Time in 1 Post
|
|
Re: M$ Excel
Is there a way to reverse concatenate something?
|
October 25th, 2002, 05:48 PM
|
 |
Shrapnel Fanatic
|
|
Join Date: Feb 2001
Location: Waterloo, Ontario, Canada
Posts: 11,451
Thanks: 1
Thanked 4 Times in 4 Posts
|
|
Re: M$ Excel
You mean to take a substring?
__________________
Things you want:
|
October 25th, 2002, 08:49 PM
|
|
Corporal
|
|
Join Date: Mar 2002
Location: Washington DC
Posts: 185
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: M$ Excel
There is the text to columns option, but that would require you to have some kind of delimiting character such as a space or a comma or tab.
I am not sure about being able to use a FCN to do it, though I am long since past my prime Excel days.
Cheers!
__________________
'To slander, Trajan paid little heed, and he was no slave of anger.'
-Dio Cassius, Book LXVIII
|
October 25th, 2002, 09:50 PM
|
|
National Security Advisor
|
|
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 4 Times in 1 Post
|
|
Re: M$ Excel
I am pretty sure a macro could do it, but those aren't my area of expertise.  It might be possible with a simple formula. I'll have to play a bit and see if I can figure out a way.
Geoschmo
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|
Asteroids Champion!
Hybrid Mode