Deleting Leading Characters

I

intheway

I just exported a file from monarch to excel. Unfortunately, some of th
columns have a leading (') in each of the cells. I tried using TRIM, bu
it did not work. How can I delete the leading character (')? I have 50
rows with multiple columns :
 
F

Frank Kabel

Hi
try the following macro

sub foo()
dim rng as range
set rng = selection
rng.value=rng.value
end sub
 
R

RagDyer

Since you can't use "Edit & Replace" for this, and if you prefer not to use
code, you still have a couple of options.

1 ] Right click in a new, unused cell and choose "Copy".
Select all your "bad" cells, and right click in the selection.
Choose "PasteSpecial", and then click on "Add", then <OK>.

2 ] On a column by column basis, simply open and close "TextToColumns".
Select the "bad" cells, then:
<Data> <TextToColumns> <Finish>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I just exported a file from monarch to excel. Unfortunately, some of the
columns have a leading (') in each of the cells. I tried using TRIM, but
it did not work. How can I delete the leading character (')? I have 500
rows with multiple columns :(
 
Top