MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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