Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I retrive data | New Users to Excel | |||
retrive data | Excel Discussion (Misc queries) | |||
Retrive Data from Multiple Cells | Excel Discussion (Misc queries) | |||
retrive data from oher sheet on a condition | Excel Discussion (Misc queries) | |||
Look for and Retrive Data | Excel Worksheet Functions |