| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Entry
Can someone tell me step by step how to make text entry appear in a cell as a
suffix automatically after I make an entry...ex....type 123 in cell A1..I want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the entire column. Can anyone help? -- Arthur |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Entry
Format Cells... Number Custom General"sm.jpg"
-- Gary''s Student - gsnu200761 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Entry
This worked great! Thank You Gary, now how can I copy from column A and paste
to column B and make the same action occur? -- Arthur "Newbie" wrote: Can someone tell me step by step how to make text entry appear in a cell as a suffix automatically after I make an entry...ex....type 123 in cell A1..I want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the entire column. Can anyone help? -- Arthur |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Entry
Assuming you have the cells pre-formatted to your special format, then try
Copy PasteSpecial Values, instead of just plain Copy Paste, as that copies the formatting as well as the values. Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: This worked great! Thank You Gary, now how can I copy from column A and paste to column B and make the same action occur? -- Arthur "Newbie" wrote: Can someone tell me step by step how to make text entry appear in a cell as a suffix automatically after I make an entry...ex....type 123 in cell A1..I want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the entire column. Can anyone help? -- Arthur |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Entry
Chuck ....this is a fabulous thing for me... Thanks a MILLION!...
one last question....can I possibly copy "tally taylor 123" from column A and special paste it to coluimn B and make the sm.jpg attach....result.....tally taylor 123sm.jpg -- Arthur "CLR" wrote: Assuming you have the cells pre-formatted to your special format, then try Copy PasteSpecial Values, instead of just plain Copy Paste, as that copies the formatting as well as the values. Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: This worked great! Thank You Gary, now how can I copy from column A and paste to column B and make the same action occur? -- Arthur "Newbie" wrote: Can someone tell me step by step how to make text entry appear in a cell as a suffix automatically after I make an entry...ex....type 123 in cell A1..I want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the entire column. Can anyone help? -- Arthur |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Entry
Not as far as I know without using a macro..........but if you are just
wanting to add "sm.jpg" to all the values in column A, then put this in B1 or B2 and copy down =A1&"sm.jpg" But, on the other hand, if you are wanting a listing of all the .jpg's in a directory, then Jim Cone has a nifty little commercial Add-in called ListFiles that will do it for you automatically and make the list all live links also if you wish. It's available at http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: Chuck ....this is a fabulous thing for me... Thanks a MILLION!... one last question....can I possibly copy "tally taylor 123" from column A and special paste it to coluimn B and make the sm.jpg attach....result.....tally taylor 123sm.jpg -- Arthur "CLR" wrote: Assuming you have the cells pre-formatted to your special format, then try Copy PasteSpecial Values, instead of just plain Copy Paste, as that copies the formatting as well as the values. Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: This worked great! Thank You Gary, now how can I copy from column A and paste to column B and make the same action occur? -- Arthur "Newbie" wrote: Can someone tell me step by step how to make text entry appear in a cell as a suffix automatically after I make an entry...ex....type 123 in cell A1..I want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the entire column. Can anyone help? -- Arthur |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Entry
Hey Chuck.....Man.....I love you Bro.....you have made my life so
easy...you're the man..THANKS & MERRY CHRISTMAS!!!!! -- Arthur "CLR" wrote: Not as far as I know without using a macro..........but if you are just wanting to add "sm.jpg" to all the values in column A, then put this in B1 or B2 and copy down =A1&"sm.jpg" But, on the other hand, if you are wanting a listing of all the .jpg's in a directory, then Jim Cone has a nifty little commercial Add-in called ListFiles that will do it for you automatically and make the list all live links also if you wish. It's available at http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: Chuck ....this is a fabulous thing for me... Thanks a MILLION!... one last question....can I possibly copy "tally taylor 123" from column A and special paste it to coluimn B and make the sm.jpg attach....result.....tally taylor 123sm.jpg -- Arthur "CLR" wrote: Assuming you have the cells pre-formatted to your special format, then try Copy PasteSpecial Values, instead of just plain Copy Paste, as that copies the formatting as well as the values. Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: This worked great! Thank You Gary, now how can I copy from column A and paste to column B and make the same action occur? -- Arthur "Newbie" wrote: Can someone tell me step by step how to make text entry appear in a cell as a suffix automatically after I make an entry...ex....type 123 in cell A1..I want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the entire column. Can anyone help? -- Arthur |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic Entry
You're welcome Arthur, and thanks for the feedback.
Merry Christmas to you and yours as well........ Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: Hey Chuck.....Man.....I love you Bro.....you have made my life so easy...you're the man..THANKS & MERRY CHRISTMAS!!!!! -- Arthur "CLR" wrote: Not as far as I know without using a macro..........but if you are just wanting to add "sm.jpg" to all the values in column A, then put this in B1 or B2 and copy down =A1&"sm.jpg" But, on the other hand, if you are wanting a listing of all the .jpg's in a directory, then Jim Cone has a nifty little commercial Add-in called ListFiles that will do it for you automatically and make the list all live links also if you wish. It's available at http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: Chuck ....this is a fabulous thing for me... Thanks a MILLION!... one last question....can I possibly copy "tally taylor 123" from column A and special paste it to coluimn B and make the sm.jpg attach....result.....tally taylor 123sm.jpg -- Arthur "CLR" wrote: Assuming you have the cells pre-formatted to your special format, then try Copy PasteSpecial Values, instead of just plain Copy Paste, as that copies the formatting as well as the values. Vaya con Dios, Chuck, CABGx3 "Newbie" wrote: This worked great! Thank You Gary, now how can I copy from column A and paste to column B and make the same action occur? -- Arthur "Newbie" wrote: Can someone tell me step by step how to make text entry appear in a cell as a suffix automatically after I make an entry...ex....type 123 in cell A1..I want sm.jpg to automatically thereafter....123sm.jpg. How can I formulate the entire column. Can anyone help? -- Arthur |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this possible ? Automatic cell entry | Excel Discussion (Misc queries) | |||
| Automatic data entry | Excel Discussion (Misc queries) | |||
| Automatic cell entry | Excel Discussion (Misc queries) | |||
| Automatic Date Entry | Excel Worksheet Functions | |||
| Need help with automatic date entry | Excel Discussion (Misc queries) | |||
Linear Mode
