Hello I have a list of number in a column that there is over 22,000 is there a away I can add ".jpg" ad the end of each number? Thank you!
Hello I have a list of number in a column that there is over 22,000 is there a away I can add ".jpg" ad the end of each number? Thank you!
images float above the grid.
adding that quantity of image will probably bloat the file.
What is the image? What are you trying to do?
Hi ryanj4314
Do you just want to add ".jpg" to the end of each cell value?
If so and asumming the numbers are in column A, this formula would work.
=A2&".jpg"
Hope this helps
Jim
Doh! I should have read that more carefully
Thats working but i keep getting =#REF! on the other cells, I have been putting the formula in then copied it hightlighted all the cells in Column A and paste and i get =#REF! what am i doing wrong?
you put it in another column say col b and drag down
once done you can select the whole column copy and paste special straight back as values
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
got it works great thanks everyone!!
Another quick question if I have colum A,B,C is there a way to take everything from those 3 columns and put them into one? thanks!
same applies
=a1&b1&c1
if you want spaces you can put them in as well
=a1&" "&b1&" "&c1
or you could use the concatenate function
=concatenate(a1,b1,c1)
or
=concatenate(a1," ",b1," ",c1)
Okay this is the last question I promise! If I have a colum in Column Z it has a Y or N if it is shippable, is there a away to remove any row that is containing N ?
Without using a macro, the easiest way would be to sort the data by column Z, that way all of the "N"'s will be together. you can then delete the rows you dont need.
Hope this helps
Jim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks