hOW to retrive the Data after did UPPERCASE
 

I tried this =upper(A1) formula to change the case of A1 Cell text.
After changed the A1 cell text in B1 Cell, I deleted the A1 lowercase
text at the same time B1 cell text also deleting, so confirm me how i
have to do.

thanks & regards


shobs



--
shobsrangan
------------------------------------------------------------------------
shobsrangan's Profile: http://www.excelforum.com/member.php...o&userid=32020
View this thread: http://www.excelforum.com/showthread...hreadid=517723

hOW to retrive the Data after did UPPERCASE
 

Hi Shobs,

Try the Undo feature.


---
Regards,
Norman



"shobsrangan"
wrote in message
...

I tried this =upper(A1) formula to change the case of A1 Cell text.
After changed the A1 cell text in B1 Cell, I deleted the A1 lowercase
text at the same time B1 cell text also deleting, so confirm me how i
have to do.

thanks & regards


shobs



--
shobsrangan
------------------------------------------------------------------------
shobsrangan's Profile:
http://www.excelforum.com/member.php...o&userid=32020
View this thread: http://www.excelforum.com/showthread...hreadid=517723

hOW to retrive the Data after did UPPERCASE
 

after you put formula in

COPY

then, from the Edit menu -- Paste Special - Values

this will trun the formulas into the values and then you can
delete the source cells, move them, etc

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com



shobsrangan wrote:
I tried this =upper(A1) formula to change the case of A1 Cell text.
After changed the A1 cell text in B1 Cell, I deleted the A1 lowercase
text at the same time B1 cell text also deleting, so confirm me how i
have to do.

thanks & regards


shobs