Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2009, 10:58 AM
00don 00don is offline
Novice
This may be impossible, but I thought I would ask...
 
Join Date: Mar 2009
Posts: 2
00don is on a distinguished road
Default This may be impossible, but I thought I would ask...

I need to conceal information on a spreadsheet... text of first name and last name (separate columns) leaving just the first letter of each in the cell. I know you can remove a set number of letters using (I believe) the LEN command but there many different names in each column. I tried to use REPLACE, trying "A*" to be replaced with "A" but it changed all of the names to "A".

Any ideas or workarounds that might work?

E.G.
A B A B
Change: Smith John to S J



Thanks!
Reply With Quote
  #2  
Old 03-07-2009, 09:53 AM
Schereazade Schereazade is offline This may be impossible, but I thought I would ask... Windows XP This may be impossible, but I thought I would ask... Office 2003
Novice
 
Join Date: Feb 2009
Posts: 25
Schereazade is on a distinguished road
Default Concealed Data

Hello,

Maybe this will help.

Please see attachment.

Regards,

Zade :-)
Attached Files
File Type: xls Concealed Data.xls (41.0 KB, 30 views)
Reply With Quote
  #3  
Old 03-11-2009, 09:02 AM
00don 00don is offline
Novice
This may be impossible, but I thought I would ask...
 
Join Date: Mar 2009
Posts: 2
00don is on a distinguished road
Default

YOU NAILED IT!!!!! (btw, it was commas on my machine). Thank you very much for your expertise!!
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 04:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft