Berrie, Juan, ANYONE??? Need help moving data from one column to another
Posted by Victor on September 27, 2001 12:41 PM
This is the exact problem I have, I will use only one Row as an example to make it easier:
In Column H, I have the following number:
1836
In COLUMN I, i have the following text (every line in the COLUMN I is the same number of characters and text except the numbers change):
"!m mmmm="jambScrapt:markRevote(184);">Picture and Description"!!!!
I basically want to replace the 184 in COLUMN I, with 1836 from COLUMN H.
So when this is done, the text will stay the same, but the number in COLUMN I would have been replaced with the number in column H on the same ROW. It will like this:
"!m mmmm="jambScrapt:markRevote(1836);">Picture and Description"!!!!
NOTE: The number 184 was overwritten with 1836!
I have thousands of different numbers of text in COLUMN H, and I basically want to put those numbers ROW for ROW in COLUMN I between the text.
Also, if anyone can figure this out, please let me know how to apply it to make it work? Do I stick the formula into COLUMN J, etc...?
Thanks,
Victor
Posted by Barrie Davidson on September 27, 2001 12:45 PM
Victor, use my formula I posted and put it in column J. Then select the data in column J and copy. Select column I and paste values (Edit|Paste Special|Values).
BarrieBarrie Davidson
Posted by Victor on September 27, 2001 1:12 PM
Re: Didn't Work :( :( :(
Barrie,
It still didn't work :(
I took your code:
=MID(I1,1,FIND("(",I1))&H1&RIGHT(I1,LEN(I1)-FIND(")",I1)+1)
and put that in column J. Then I selected the data in column J and copied it. I proceeded to Select column I and paste values (Edit|Paste Special|Values). What I got in Column I was the formula?
Thanks for trying anyway :(
Posted by Barrie Davidson on September 27, 2001 1:17 PM
A mystery....
It still didn't work :( I took your code:
I never like to admit defeat. Can you e-mail a sample of your file (not too big please, I'm still on dial-up at home)?
BarrieBarrie Davidson
Posted by Juan Pablo on September 27, 2001 1:19 PM
I'd like to see that too if you can
Posted by IML on September 27, 2001 2:13 PM
Re: Didn't Work :( :( :(
It still didn't work :( I took your code:
Barrie's works fine for me to. You may want to give this a shot using the same copy, paste special values over it once your done.
=REPLACE(I1,FIND("(",I1)+1,FIND(")",I1)-FIND("(",I1)-1,H1)
the only thing I can think of is
1) make sure there are no spaces or apostrophies when you put the first one in.
2) after you copy it, hit f9 to make sure your sheet is calculating.
good luck
Posted by . on September 27, 2001 4:23 PM
Perhaps you have have column J inadvertently formatted as Text ?
It still didn't work :( I took your code:
Posted by Travis on September 27, 2001 9:32 PM
It's easy to replace the numbers.
Put this in an empty column and copy it all the way down. If your data does not start in row 1 then put it in the row that your data starts in and change the 1's to the row you are in...
=LEFT(I1,31)&H1&RIGHT(I1,32)
Then highlight that whole column and select copy
then highlight column I and do a paste values. (edit>>paste special>>values)
