PC Review


Reply
Thread Tools Rate Thread

adding text in front of

 
 
the mailman
Guest
Posts: n/a
 
      21st May 2006
Hi, I would like to insert a common beginning in front of all my lines of
text on a certain collum . How do I do that , my text being different on
each lines
example from Bob
to - Bob

--
Our website :
http://timmins22.adventistchurchconnect.org/index.php

Our Bible School :
http://www.discoveronline.org/schools/647


 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      21st May 2006
try

Sub adddash()
mc=activecell.column
lr=cells(rows.count,mc).end(xlup).row
For Each c In range(cells(2,mc),cells(lr,mc))
If Len(c) > 1 Then c.Value = "- " & c
Next c
End Sub

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"the mailman" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi, I would like to insert a common beginning in front of all my lines of
> text on a certain collum . How do I do that , my text being different on
> each lines
> example from Bob
> to - Bob
>
> --
> Our website :
> http://timmins22.adventistchurchconnect.org/index.php
>
> Our Bible School :
> http://www.discoveronline.org/schools/647
>



 
Reply With Quote
 
Bill Kuunders
Guest
Posts: n/a
 
      21st May 2006
one way
say your names are in column B
insert a new column C
enter in C1 ="- "&B1
extend this down the column
to change the formula's to data
edit copy, edit paste special, values, on the C column

delete the original column B

--
Greetings from New Zealand
Bill K

"the mailman" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi, I would like to insert a common beginning in front of all my lines of
> text on a certain collum . How do I do that , my text being different on
> each lines
> example from Bob
> to - Bob
>
> --
> Our website :
> http://timmins22.adventistchurchconnect.org/index.php
>
> Our Bible School :
> http://www.discoveronline.org/schools/647
>



 
Reply With Quote
 
the mailman
Guest
Posts: n/a
 
      21st May 2006
interesting but when I delete the original collum all the reference are gone
and you know what I get a bunch of ref

--
Our website :
http://timmins22.adventistchurchconnect.org/index.php

Our Bible School :
http://www.discoveronline.org/schools/647
"Bill Kuunders" <(E-Mail Removed)> wrote in message
news:%23K1L%(E-Mail Removed)...
> one way
> say your names are in column B
> insert a new column C
> enter in C1 ="- "&B1
> extend this down the column
> to change the formula's to data
> edit copy, edit paste special, values, on the C column
>
> delete the original column B
>
> --
> Greetings from New Zealand
> Bill K
>
> "the mailman" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Hi, I would like to insert a common beginning in front of all my lines of
>> text on a certain collum . How do I do that , my text being different on
>> each lines
>> example from Bob
>> to - Bob
>>
>> --
>> Our website :
>> http://timmins22.adventistchurchconnect.org/index.php
>>
>> Our Bible School :
>> http://www.discoveronline.org/schools/647
>>

>
>



 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      21st May 2006
If you want to do it that way, when all else fails, RTFI
>to change the formula's to data
>edit copy, edit paste special, values, on the C column



--
Don Guillett
SalesAid Software
(E-Mail Removed)
"the mailman" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> interesting but when I delete the original collum all the reference are
> gone and you know what I get a bunch of ref
>
> --
> Our website :
> http://timmins22.adventistchurchconnect.org/index.php
>
> Our Bible School :
> http://www.discoveronline.org/schools/647
> "Bill Kuunders" <(E-Mail Removed)> wrote in message
> news:%23K1L%(E-Mail Removed)...
>> one way
>> say your names are in column B
>> insert a new column C
>> enter in C1 ="- "&B1
>> extend this down the column
>> to change the formula's to data
>> edit copy, edit paste special, values, on the C column
>>
>> delete the original column B
>>
>> --
>> Greetings from New Zealand
>> Bill K
>>
>> "the mailman" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Hi, I would like to insert a common beginning in front of all my lines
>>> of text on a certain collum . How do I do that , my text being different
>>> on each lines
>>> example from Bob
>>> to - Bob
>>>
>>> --
>>> Our website :
>>> http://timmins22.adventistchurchconnect.org/index.php
>>>
>>> Our Bible School :
>>> http://www.discoveronline.org/schools/647
>>>

>>
>>

>
>



 
Reply With Quote
 
the mailman
Guest
Posts: n/a
 
      21st May 2006
I am trying both method and both don't work sorry for the suggestion with
both collum it gives me the same value on all the lines

--
Our website :
http://timmins22.adventistchurchconnect.org/index.php

Our Bible School :
http://www.discoveronline.org/schools/647
"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If you want to do it that way, when all else fails, RTFI
>>to change the formula's to data
>>edit copy, edit paste special, values, on the C column

>
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "the mailman" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> interesting but when I delete the original collum all the reference are
>> gone and you know what I get a bunch of ref
>>
>> --
>> Our website :
>> http://timmins22.adventistchurchconnect.org/index.php
>>
>> Our Bible School :
>> http://www.discoveronline.org/schools/647
>> "Bill Kuunders" <(E-Mail Removed)> wrote in message
>> news:%23K1L%(E-Mail Removed)...
>>> one way
>>> say your names are in column B
>>> insert a new column C
>>> enter in C1 ="- "&B1
>>> extend this down the column
>>> to change the formula's to data
>>> edit copy, edit paste special, values, on the C column
>>>
>>> delete the original column B
>>>
>>> --
>>> Greetings from New Zealand
>>> Bill K
>>>
>>> "the mailman" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Hi, I would like to insert a common beginning in front of all my lines
>>>> of text on a certain collum . How do I do that , my text being
>>>> different on each lines
>>>> example from Bob
>>>> to - Bob
>>>>
>>>> --
>>>> Our website :
>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>
>>>> Our Bible School :
>>>> http://www.discoveronline.org/schools/647
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      21st May 2006
Both methods WILL WORK. If you like send me your workbook.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"the mailman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am trying both method and both don't work sorry for the suggestion with
>both collum it gives me the same value on all the lines
>
> --
> Our website :
> http://timmins22.adventistchurchconnect.org/index.php
>
> Our Bible School :
> http://www.discoveronline.org/schools/647
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> If you want to do it that way, when all else fails, RTFI
>>>to change the formula's to data
>>>edit copy, edit paste special, values, on the C column

>>
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "the mailman" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> interesting but when I delete the original collum all the reference are
>>> gone and you know what I get a bunch of ref
>>>
>>> --
>>> Our website :
>>> http://timmins22.adventistchurchconnect.org/index.php
>>>
>>> Our Bible School :
>>> http://www.discoveronline.org/schools/647
>>> "Bill Kuunders" <(E-Mail Removed)> wrote in message
>>> news:%23K1L%(E-Mail Removed)...
>>>> one way
>>>> say your names are in column B
>>>> insert a new column C
>>>> enter in C1 ="- "&B1
>>>> extend this down the column
>>>> to change the formula's to data
>>>> edit copy, edit paste special, values, on the C column
>>>>
>>>> delete the original column B
>>>>
>>>> --
>>>> Greetings from New Zealand
>>>> Bill K
>>>>
>>>> "the mailman" <(E-Mail Removed)> wrote in message
>>>> news:%(E-Mail Removed)...
>>>>> Hi, I would like to insert a common beginning in front of all my lines
>>>>> of text on a certain collum . How do I do that , my text being
>>>>> different on each lines
>>>>> example from Bob
>>>>> to - Bob
>>>>>
>>>>> --
>>>>> Our website :
>>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>>
>>>>> Our Bible School :
>>>>> http://www.discoveronline.org/schools/647
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
the mailman
Guest
Posts: n/a
 
      21st May 2006
I hope I am doing something right here

Travel # module / site compartment box names RR # or LB Month 911 #
NUMBERED COMPANY
moved - 405461 LB
moved - 534806 LB
407 - 535172 LB
603 - 535172 LB
moved - 707835 LB
10 - 872877 LB
10 1103730 LB
550 1262472 LB
583 1311643 LB
550 1362472 LB
602 1543776 LB
330 1582643 LB
608 1599212 LB
48 1606068 LB
190 2024718 LB
415 2043767 LB
77 1239104 Ont Inc c/o Graham Dudley RR2 NOV 1241
119 143468163RP0001 LB
1 145 -2847ONT. INC. c/oPHIPPS Harley RR3 DEC 5816
47 2 15 GMB 1452847 Ont Inc c/oZours,Olaf RR2 DEC 1309
23 1617434 ON. INC c/o TRUSSLER RR2 DEC 1241
51 1639752 ONT INC. NOT # 51
190 2024718 ONTARIO LIMITED LB
74 2089176 ONT. INC. c/o Joe Desrochers RR2 JULY 5730
22 2757-6610 Que Inc c/o Dupuis RR2 OCT 1288
523 495988 ONTARIO LIMITED LB
389 534805 HOLDING CO LB
12 1 0 GMB 647200 ONT. INC. c/o BUTLER LAKE TRUCK STOP RR1 DEC 6378
353 9030-4965 Inc. LB
504 9068-3962 Que INC LB
Travel # module / site compartment box names RR # or LB Month 911 #
A
209 A & A GROUP LB
190 A & G FRESHMART LB
61 A&A AUTO ELECTRIC RR2 NOV 1575
516 A.P.S. SERVICES LB
112 ABORIGINAL HEALING LB
565 AGRICULTURE SOCIETY LB
407 AITCHISON,Robert,Joyce,Jack LB
17 1 6 GMB AKULICK,Alex,Geneva RR1 MAR
9 RMB AKULICK,William,Paul RR1 NOV 2370
130 ALARIE CONSTRUCTION LB
130 ALARIE Eddie Shirley Marcel LB


--
Our website :
http://timmins22.adventistchurchconnect.org/index.php

Our Bible School :
http://www.discoveronline.org/schools/647
"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Both methods WILL WORK. If you like send me your workbook.
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "the mailman" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I am trying both method and both don't work sorry for the suggestion with
>>both collum it gives me the same value on all the lines
>>
>> --
>> Our website :
>> http://timmins22.adventistchurchconnect.org/index.php
>>
>> Our Bible School :
>> http://www.discoveronline.org/schools/647
>> "Don Guillett" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> If you want to do it that way, when all else fails, RTFI
>>>>to change the formula's to data
>>>>edit copy, edit paste special, values, on the C column
>>>
>>>
>>> --
>>> Don Guillett
>>> SalesAid Software
>>> (E-Mail Removed)
>>> "the mailman" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> interesting but when I delete the original collum all the reference are
>>>> gone and you know what I get a bunch of ref
>>>>
>>>> --
>>>> Our website :
>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>
>>>> Our Bible School :
>>>> http://www.discoveronline.org/schools/647
>>>> "Bill Kuunders" <(E-Mail Removed)> wrote in message
>>>> news:%23K1L%(E-Mail Removed)...
>>>>> one way
>>>>> say your names are in column B
>>>>> insert a new column C
>>>>> enter in C1 ="- "&B1
>>>>> extend this down the column
>>>>> to change the formula's to data
>>>>> edit copy, edit paste special, values, on the C column
>>>>>
>>>>> delete the original column B
>>>>>
>>>>> --
>>>>> Greetings from New Zealand
>>>>> Bill K
>>>>>
>>>>> "the mailman" <(E-Mail Removed)> wrote in message
>>>>> news:%(E-Mail Removed)...
>>>>>> Hi, I would like to insert a common beginning in front of all my
>>>>>> lines of text on a certain collum . How do I do that , my text being
>>>>>> different on each lines
>>>>>> example from Bob
>>>>>> to - Bob
>>>>>>
>>>>>> --
>>>>>> Our website :
>>>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>>>
>>>>>> Our Bible School :
>>>>>> http://www.discoveronline.org/schools/647
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      22nd May 2006
Care to explain. Mindreading not working well this morning.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"the mailman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I hope I am doing something right here
>
> Travel # module / site compartment box names RR # or LB Month 911 #
> NUMBERED COMPANY
> moved - 405461 LB
> moved - 534806 LB
> 407 - 535172 LB
> 603 - 535172 LB
> moved - 707835 LB
> 10 - 872877 LB
> 10 1103730 LB
> 550 1262472 LB
> 583 1311643 LB
> 550 1362472 LB
> 602 1543776 LB
> 330 1582643 LB
> 608 1599212 LB
> 48 1606068 LB
> 190 2024718 LB
> 415 2043767 LB
> 77 1239104 Ont Inc c/o Graham Dudley RR2 NOV 1241
> 119 143468163RP0001 LB
> 1 145 -2847ONT. INC. c/oPHIPPS Harley RR3 DEC 5816
> 47 2 15 GMB 1452847 Ont Inc c/oZours,Olaf RR2 DEC 1309
> 23 1617434 ON. INC c/o TRUSSLER RR2 DEC 1241
> 51 1639752 ONT INC. NOT # 51
> 190 2024718 ONTARIO LIMITED LB
> 74 2089176 ONT. INC. c/o Joe Desrochers RR2 JULY 5730
> 22 2757-6610 Que Inc c/o Dupuis RR2 OCT 1288
> 523 495988 ONTARIO LIMITED LB
> 389 534805 HOLDING CO LB
> 12 1 0 GMB 647200 ONT. INC. c/o BUTLER LAKE TRUCK STOP RR1 DEC 6378
> 353 9030-4965 Inc. LB
> 504 9068-3962 Que INC LB
> Travel # module / site compartment box names RR # or LB Month 911 #
> A
> 209 A & A GROUP LB
> 190 A & G FRESHMART LB
> 61 A&A AUTO ELECTRIC RR2 NOV 1575
> 516 A.P.S. SERVICES LB
> 112 ABORIGINAL HEALING LB
> 565 AGRICULTURE SOCIETY LB
> 407 AITCHISON,Robert,Joyce,Jack LB
> 17 1 6 GMB AKULICK,Alex,Geneva RR1 MAR
> 9 RMB AKULICK,William,Paul RR1 NOV 2370
> 130 ALARIE CONSTRUCTION LB
> 130 ALARIE Eddie Shirley Marcel LB
>
>
> --
> Our website :
> http://timmins22.adventistchurchconnect.org/index.php
>
> Our Bible School :
> http://www.discoveronline.org/schools/647
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Both methods WILL WORK. If you like send me your workbook.
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "the mailman" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I am trying both method and both don't work sorry for the suggestion with
>>>both collum it gives me the same value on all the lines
>>>
>>> --
>>> Our website :
>>> http://timmins22.adventistchurchconnect.org/index.php
>>>
>>> Our Bible School :
>>> http://www.discoveronline.org/schools/647
>>> "Don Guillett" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> If you want to do it that way, when all else fails, RTFI
>>>>>to change the formula's to data
>>>>>edit copy, edit paste special, values, on the C column
>>>>
>>>>
>>>> --
>>>> Don Guillett
>>>> SalesAid Software
>>>> (E-Mail Removed)
>>>> "the mailman" <(E-Mail Removed)> wrote in message
>>>> news:%(E-Mail Removed)...
>>>>> interesting but when I delete the original collum all the reference
>>>>> are gone and you know what I get a bunch of ref
>>>>>
>>>>> --
>>>>> Our website :
>>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>>
>>>>> Our Bible School :
>>>>> http://www.discoveronline.org/schools/647
>>>>> "Bill Kuunders" <(E-Mail Removed)> wrote in message
>>>>> news:%23K1L%(E-Mail Removed)...
>>>>>> one way
>>>>>> say your names are in column B
>>>>>> insert a new column C
>>>>>> enter in C1 ="- "&B1
>>>>>> extend this down the column
>>>>>> to change the formula's to data
>>>>>> edit copy, edit paste special, values, on the C column
>>>>>>
>>>>>> delete the original column B
>>>>>>
>>>>>> --
>>>>>> Greetings from New Zealand
>>>>>> Bill K
>>>>>>
>>>>>> "the mailman" <(E-Mail Removed)> wrote in message
>>>>>> news:%(E-Mail Removed)...
>>>>>>> Hi, I would like to insert a common beginning in front of all my
>>>>>>> lines of text on a certain collum . How do I do that , my text being
>>>>>>> different on each lines
>>>>>>> example from Bob
>>>>>>> to - Bob
>>>>>>>
>>>>>>> --
>>>>>>> Our website :
>>>>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>>>>
>>>>>>> Our Bible School :
>>>>>>> http://www.discoveronline.org/schools/647
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      22nd May 2006
Please do NOT attach files to this ng.

You STILL have not explained what you want. Do you want to add a dash to all
cells in column c or part of c or what, if there is not already a dash
there? Again, mindreading mode turned off. If you can't tell us what you
want, we can't help you.


--
Don Guillett
SalesAid Software
(E-Mail Removed)
"the mailman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> sorry here is a part of it to save space
>
> --
> Our website :
> http://timmins22.adventistchurchconnect.org/index.php
>
> Our Bible School :
> http://www.discoveronline.org/schools/647
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Care to explain. Mindreading not working well this morning.
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "the mailman" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>>I hope I am doing something right here
>>>
>>> Travel # module / site compartment box names RR # or LB Month 911
>>> #
>>> NUMBERED COMPANY
>>> moved - 405461 LB
>>> moved - 534806 LB
>>> 407 - 535172 LB
>>> 603 - 535172 LB
>>> moved - 707835 LB
>>> 10 - 872877 LB
>>> 10 1103730 LB
>>> 550 1262472 LB
>>> 583 1311643 LB
>>> 550 1362472 LB
>>> 602 1543776 LB
>>> 330 1582643 LB
>>> 608 1599212 LB
>>> 48 1606068 LB
>>> 190 2024718 LB
>>> 415 2043767 LB
>>> 77 1239104 Ont Inc c/o Graham Dudley RR2 NOV 1241
>>> 119 143468163RP0001 LB
>>> 1 145 -2847ONT. INC. c/oPHIPPS Harley RR3 DEC 5816
>>> 47 2 15 GMB 1452847 Ont Inc c/oZours,Olaf RR2 DEC 1309
>>> 23 1617434 ON. INC c/o TRUSSLER RR2 DEC 1241
>>> 51 1639752 ONT INC. NOT # 51
>>> 190 2024718 ONTARIO LIMITED LB
>>> 74 2089176 ONT. INC. c/o Joe Desrochers RR2 JULY 5730
>>> 22 2757-6610 Que Inc c/o Dupuis RR2 OCT 1288
>>> 523 495988 ONTARIO LIMITED LB
>>> 389 534805 HOLDING CO LB
>>> 12 1 0 GMB 647200 ONT. INC. c/o BUTLER LAKE TRUCK STOP RR1 DEC 6378
>>> 353 9030-4965 Inc. LB
>>> 504 9068-3962 Que INC LB
>>> Travel # module / site compartment box names RR # or LB Month 911
>>> #
>>> A
>>> 209 A & A GROUP LB
>>> 190 A & G FRESHMART LB
>>> 61 A&A AUTO ELECTRIC RR2 NOV 1575
>>> 516 A.P.S. SERVICES LB
>>> 112 ABORIGINAL HEALING LB
>>> 565 AGRICULTURE SOCIETY LB
>>> 407 AITCHISON,Robert,Joyce,Jack LB
>>> 17 1 6 GMB AKULICK,Alex,Geneva RR1 MAR
>>> 9 RMB AKULICK,William,Paul RR1 NOV 2370
>>> 130 ALARIE CONSTRUCTION LB
>>> 130 ALARIE Eddie Shirley Marcel LB
>>>
>>>
>>> --
>>> Our website :
>>> http://timmins22.adventistchurchconnect.org/index.php
>>>
>>> Our Bible School :
>>> http://www.discoveronline.org/schools/647
>>> "Don Guillett" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Both methods WILL WORK. If you like send me your workbook.
>>>>
>>>> --
>>>> Don Guillett
>>>> SalesAid Software
>>>> (E-Mail Removed)
>>>> "the mailman" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>>I am trying both method and both don't work sorry for the suggestion
>>>>>with
>>>>>both collum it gives me the same value on all the lines
>>>>>
>>>>> --
>>>>> Our website :
>>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>>
>>>>> Our Bible School :
>>>>> http://www.discoveronline.org/schools/647
>>>>> "Don Guillett" <(E-Mail Removed)> wrote in message
>>>>> news:(E-Mail Removed)...
>>>>>> If you want to do it that way, when all else fails, RTFI
>>>>>>>to change the formula's to data
>>>>>>>edit copy, edit paste special, values, on the C column
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Don Guillett
>>>>>> SalesAid Software
>>>>>> (E-Mail Removed)
>>>>>> "the mailman" <(E-Mail Removed)> wrote in message
>>>>>> news:%(E-Mail Removed)...
>>>>>>> interesting but when I delete the original collum all the reference
>>>>>>> are gone and you know what I get a bunch of ref
>>>>>>>
>>>>>>> --
>>>>>>> Our website :
>>>>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>>>>
>>>>>>> Our Bible School :
>>>>>>> http://www.discoveronline.org/schools/647
>>>>>>> "Bill Kuunders" <(E-Mail Removed)> wrote in message
>>>>>>> news:%23K1L%(E-Mail Removed)...
>>>>>>>> one way
>>>>>>>> say your names are in column B
>>>>>>>> insert a new column C
>>>>>>>> enter in C1 ="- "&B1
>>>>>>>> extend this down the column
>>>>>>>> to change the formula's to data
>>>>>>>> edit copy, edit paste special, values, on the C column
>>>>>>>>
>>>>>>>> delete the original column B
>>>>>>>>
>>>>>>>> --
>>>>>>>> Greetings from New Zealand
>>>>>>>> Bill K
>>>>>>>>
>>>>>>>> "the mailman" <(E-Mail Removed)> wrote in message
>>>>>>>> news:%(E-Mail Removed)...
>>>>>>>>> Hi, I would like to insert a common beginning in front of all my
>>>>>>>>> lines of text on a certain collum . How do I do that , my text
>>>>>>>>> being
>>>>>>>>> different on each lines
>>>>>>>>> example from Bob
>>>>>>>>> to - Bob
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Our website :
>>>>>>>>> http://timmins22.adventistchurchconnect.org/index.php
>>>>>>>>>
>>>>>>>>> Our Bible School :
>>>>>>>>> http://www.discoveronline.org/schools/647
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>

>>
>>

>
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding zero in front of a letter Lisa W. Microsoft Access Queries 2 18th Jun 2008 02:04 PM
text boxes or clip art in front of text not printing in Word 2007 =?Utf-8?B?QXJsZW5l?= Microsoft Word Document Management 0 24th Jan 2007 11:20 PM
Adding Dashes in front of text using text formating =?Utf-8?B?TmVhbA==?= Microsoft Excel Misc 1 27th Nov 2006 10:58 PM
Formula for adding a comma in front of text in a cell =?Utf-8?B?U2hlbGxleQ==?= Microsoft Excel Worksheet Functions 4 18th Apr 2005 04:34 PM
Adding TEXT in front of a DATE formula RayD Microsoft Excel Misc 6 9th Oct 2003 09:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:54 AM.