View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fuzzyjon
 
Posts: n/a
Default Deleting the same character automatically in each cell


Hi there everyone,

I have some data which has been output from our database into Excel.

The data takes the form of Company name, address, website, e-mail etc
(all in separate columns).

Before each bit of data in every cell there appears to be a '

... so, the data looks like....

'ABC Ltd
'42 High Street
'www.abc.com

.... etc.....

However, if you look at the actual cell you cannot see the ' (you can
only see it in the formula bar).

Is there any way to automatically delete this in every cell without
manually going through the data?

Thanks for your help.

Jon


--
fuzzyjon
------------------------------------------------------------------------
fuzzyjon's Profile: http://www.excelforum.com/member.php...o&userid=34378
View this thread: http://www.excelforum.com/showthread...hreadid=542091