Copying partial text/number?

Mar 12th, 2002, 08:32 AM

Hello
I am wondering is there a formula to copy part of a text/number to another cell?
e.g Weight = 233
copy 233 to another cell

NateO · Mar 12th, 2002, 10:01 AM

Yes, in this case, if your original text is in cell a1, use the following:

=RIGHT(a1,3)+0

The 0 converts the new string to a number.

Cheers, Nate

[ This Message was edited by: NateO on 2002-03-12 09:02 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 08:32 AM	#1
Guest Posts: n/a	Hello I am wondering is there a formula to copy part of a text/number to another cell? e.g Weight = 233 copy 233 to another cell

Mar 12th, 2002, 10:01 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Yes, in this case, if your original text is in cell a1, use the following: =RIGHT(a1,3)+0 The 0 converts the new string to a number. Cheers, Nate [ This Message was edited by: NateO on 2002-03-12 09:02 ]