Sorry Guys, didn't paste right ,.HERE IS THE RIGHT ONE
Posted by Victor on September 27, 2001 10:57 AM
Hard to understand your formulas...let me type in exactly what I need to do below.
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:
"Picture and Description"
I basically want to replace the 184 in COLUMN I, with 1836 from COLUMN H.
So when this is done, the number text and number in COLUMN I will look like this:
"Picture and Description"
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.
Thanks again,
Victor
Posted by Victor on September 27, 2001 11:02 AM
THE TEXT WAS A URL, but it turned into that...
COLUMN I contains the following info:
avaScript:makeRemote(184);">Picture and Descripti
want to move the number from COLUMN H to replace te number in COLUMN I
it's actually a hyperlink...but I removed some of the coding so it wouldn't turn into one this time :(
sorry
Posted by Barrie Davidson on September 27, 2001 11:08 AM
Okay, try this formula.
=MID(I1,1,FIND("(",I1))&H1&RIGHT(I1,LEN(I1)-FIND(")",I1)+1)
in column J. You can then copy column J and paste values into column H.
Regards,
Barrie
Barrie Davidson
Posted by Victor on September 27, 2001 11:13 AM
Didn't Work :(
When I do the following:
=MID(I1,1,FIND("(",I1))&H1&RIGHT(I1,LEN(I1)-FIND(")",I1)+1)
I get this is column J:
#VALUE!
I don't get it?
Please help!
Victor
Posted by Barrie Davidson on September 27, 2001 11:45 AM
Victor, the formula works okay for me. Can you post exactly what you have in I1 and H1, and post it in a fashion that the message board doesn't create gibberish?
Does I1 contain an opening bracket "(" and a closing bracket ")"? I think that is where your error is coming from.Barrie Davidson
Posted by Juan Pablo on September 27, 2001 12:00 PM
Try this one...
=LEFT(I1,FIND("(",I1))&H1&RIGHT(I1,LEN(I1)-FIND(")",I1)+1)
Your value in I1 is ? (without all the spaces)
ja va scr ipt : makere mo te (184)
?
If it is, then the formula works for me.
Juan Pablo
--------------
Posted by Victor on September 27, 2001 12:18 PM
BARRIE...I will try to post this exactly as it is...but column I contains a hyperlink.
Say Column H ROW 1 contains a number.
On ROW 1 COLUMN H...the number is 1840
Now,
On ROW 1 COLUMN I...I have a the following HREF pointing to a webpage. Below is the exact coding except for the href tag. I changed it so that it wouldn't form a link in this message board.
"Picture and Description</c>"
That is the exact coding!
Now I have 1000 Rows containing different numbers in COLUMN H (for example, some are 1234 and others are 23) and would like to insert these numbers across the same row to COLUMN I and replace the numbers around the ( ) in COLUMN I...row for row. The text in COLUMN I is all the same except for the numbers, they change with each row.
I just wanna move the number from COLUMN H to the replace the number in COLUMN I on each row.
If you can figure this out, please tell me what i need to do exactly. Do I take your code paste it into column J and it figures out the formula for itself?
THANK YOU SO MUCH FOR YOUR HELP!
VICTOR
Posted by Victor on September 27, 2001 12:22 PM
IT DID IT AGAIN...change the whole wording this time!
IT STILL CREATED A STUPID HYPERLINK!!!
LEt me change the wording exactly so it doesn't represent the hyperlink...
SAY COLUMN I contains the following wording with qoutes at the beginning and end. I will just change the whole wording but maintain the spaces and punctuation, etc...
So say column I is:
"m mmmm="jambScrapt:markRevote(1840);">Punture and Description<aa>"
Posted by Barrie Davidson on September 27, 2001 12:23 PM
Re: BARRIE...I will try to post this exactly as it is...but column I contains a hyperlink.
Yup, that's all it should take. Note, the formula will not result with an HREF.
Let me know,
Barrie
Barrie Davidson
