Thread: how do i use format cells to alpha / numeric values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Samvid69 Samvid69 is offline
external usenet poster
  
Posts: 1
Default how do i use format cells to alpha / numeric values
HAVE A STRING OF DATA i WANT TO ENTER into a cell, but I also want to set
format to set the values. eg. if I put in asd123 I want it to appear as
ASD123 but there are also occasions when I will put in a different mix of
letters/numbers a12s3d, which I also want to come out as A12S3D. I can do
this in Access but cant seem to crack the code in excel.

Please help.

Reply With QuoteReply With Quote