Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exel help
Hi i'm working in exel, i have a column(A1) with these type of info in the
column ( hbdn3j , hdfeyb , ijdnhf33k ) , and so on all the way down to 1000, now i need to add to the end of these (.jpg ) all the way down 1000 sets. How can i do this without going one by one and adding the ( .jpg ), i know there is a code to do this i think its, A1=&".jpg" i've used it before but i can't remember what to do with the code afterwards. HELP!!! Marshall |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exel help
no need to multipost. see other post
-- Don Guillett SalesAid Software "Morefeus Direct" wrote in message ... Hi i'm working in exel, i have a column(A1) with these type of info in the column ( hbdn3j , hdfeyb , ijdnhf33k ) , and so on all the way down to 1000, now i need to add to the end of these (.jpg ) all the way down 1000 sets. How can i do this without going one by one and adding the ( .jpg ), i know there is a code to do this i think its, A1=&".jpg" i've used it before but i can't remember what to do with the code afterwards. HELP!!! Marshall |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exel help
On Sat, 21 Oct 2006 08:40:02 -0700, Morefeus Direct
wrote: Hi i'm working in exel, i have a column(A1) with these type of info in the column ( hbdn3j , hdfeyb , ijdnhf33k ) , and so on all the way down to 1000, now i need to add to the end of these (.jpg ) all the way down 1000 sets. How can i do this without going one by one and adding the ( .jpg ), i know there is a code to do this i think its, A1=&".jpg" i've used it before but i can't remember what to do with the code afterwards. HELP!!! Marshall Nearly right. Code would be =A1&".jpg" Then to convert them all to text values, just copy A1:A1000 and Edit PasteSpecial Values to A1 HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exel help
If you have other data in the worksheet in columns B onwards, then
insert a new column B temporarily, and in B1 enter this formula: =A1&".jpg" Copy this formula down column B - a quick way is to double-click the fill handle, which is the small black square in the bottom right corner of the cursor, with B1 selected. You should now fix the values in column B to get rid of the formula. To do this, highlight column B, click <copy then Edit | Paste Special | Values (check) | OK then <Enter. You can then either delete column A or copy the values from column B to overwrite the ones in column A and delete column B. Hope this helps. Pete Morefeus Direct wrote: Hi i'm working in exel, i have a column(A1) with these type of info in the column ( hbdn3j , hdfeyb , ijdnhf33k ) , and so on all the way down to 1000, now i need to add to the end of these (.jpg ) all the way down 1000 sets. How can i do this without going one by one and adding the ( .jpg ), i know there is a code to do this i think its, A1=&".jpg" i've used it before but i can't remember what to do with the code afterwards. HELP!!! Marshall |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
exel help
in B1 use =A1&".jpg"
Copy down. Select column B, and copy Goto editPasteSpecila, and click Values, then OK Delete column A -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Morefeus Direct" wrote in message ... Hi i'm working in exel, i have a column(A1) with these type of info in the column ( hbdn3j , hdfeyb , ijdnhf33k ) , and so on all the way down to 1000, now i need to add to the end of these (.jpg ) all the way down 1000 sets. How can i do this without going one by one and adding the ( .jpg ), i know there is a code to do this i think its, A1=&".jpg" i've used it before but i can't remember what to do with the code afterwards. HELP!!! Marshall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how 2 convert (exel macro's mysql) ?? | Excel Discussion (Misc queries) | |||
how do I convert a non exel tabulation to exel | New Users to Excel | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) |