Forum Discussion
Solved
Formatting data
Hi there,
I'm hoping someone can help me out. If I have a large list of ID numbers (example format: B00123456) and I want to convert them all to this format (000123456), how would I go about doing that?
Thanks!
Do they all start with "B"?
If so, select them
then press Ctrl+H to activate the Replace dialog.
Enter B in the 'Find what' box, '0 in the 'Replace with' box (note the apostrophe), then click 'Replace All'.
2 Replies
Do they all start with "B"?
If so, select them
then press Ctrl+H to activate the Replace dialog.
Enter B in the 'Find what' box, '0 in the 'Replace with' box (note the apostrophe), then click 'Replace All'.
- Thanks so much! Yes, they all start the same. I knew there had to be a way to do this but was driving myself crazy haha (I was missing the apostrophe). Much appreciated!
