Excel 2003 formatting

By julie ·
I am exporting a client list from one software into Excel. The current software has the client last name and forst name separated by a tilda(~. Is there a way to format the Excel spreadsheet to change the tilda to a comma? I already tried find/replace.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Thank you

by julie In reply to Try this out for your Exc ...

After reading this, I knew what to do- thank you!

Collapse -

Nice to know you have solved it. :)

by Peconet Tietokoneet In reply to Thank you
Collapse -


by ThumbsUp2 In reply to Excel 2003 formatting

When you tried the find/replace, did you TYPE the tilde or did you copy it from the document and paste it into the find box? There's a difference between the two ya know.

Collapse -

Tried that

by julie In reply to Also....

I did it both ways- no go.

Related Discussions

Related Forums