How do I reformat text that contains a leading hash mark?

[Guest]

I have an Excel document containing thousands of names that represent the concatenation of a first and last name together. Everyone of them appears with a leading hash mark... example: 'JoeSmith - This causes other operations that rely on this data to not work properly. I want to get rid of this leading hash mark resulting in just - JoeSmith

 

[Jason Morin]

Select your range and do Edit > Replace. In "Find What"
insert the hash mark, and leave "Replace With" empty.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have an Excel document containing thousands of names

that represent the concatenation of a first and last name
together. Everyone of them appears with a leading hash
mark... example: 'JoeSmith - This causes other
operations that rely on this data to not work properly. I
want to get rid of this leading hash mark resulting in
just - JoeSmith

 

[Guest]

This can be done very quickly using Edit>Replace from the pulldown menu. Just leave the Replace with field blank.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Tom L wrote: -----

I have an Excel document containing thousands of names that represent the concatenation of a first and last name together. Everyone of them appears with a leading hash mark... example: 'JoeSmith - This causes other operations that rely on this data to not work properly. I want to get rid of this leading hash mark resulting in just - JoeSmith