If a number is there in A1 and I want 3 digit from left and 3 from right and rest of the digits should be replaced with "X" then the formula would be =CONCATENATE(LEFT(A1,3),"XXXX",RIGHT(A1,3))
Hope this is helpful Mukesh -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Subramani L Sent: Thursday, May 27, 2010 4:45 PM To: [email protected]; [email protected] Subject: Re: [AI] Query regarding Excel with Jaws This is quite apart for a friend of mine who is sighted. He has about a list of 1 lakh telephone numbers in Excel which he has to send to his client to let him know that he has contacted so many people, but he wants to do it without showing the numbers clearly (except for the first and the last number of a mobile contact, he wants the letter x to appear everywhere else). How can he do that? Any suggestions? Subramani -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mukesh Sharma Sent: Thursday, May 27, 2010 12:34 PM To: [email protected] Subject: Re: [AI] Query regarding Excel with Jaws Are you using non admin account? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Satguru Rathi Sent: Thursday, May 27, 2010 11:12 AM To: [email protected] Subject: [AI] Query regarding Excel with Jaws Dear list, I am using Jaws V11.0.756 and Excel 2003. While instructing Jaws to read column titles by running Jaws manager (Insert+F2) and then going to title reading options and setting my preferences, after hitting close button, jaws says "Application Settings Could Not be Saved". What might have gone wrong? Hoping for an earliest reply. Satguru. ___ "Life's battle do not always go, To the stronger or faster man. But sooner or later the one who wins, Is the one who thinks he Can." Satguru Rathi Emails: [email protected];[email protected] Skype: satgururathi Mobile:+9199 71 23 16 27 To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.i n To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.i n To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
