1 person found this helpful
Using your example of the "L" prefix...
- Select the column
- Launch the Find/Change dialog and choose the GREP tab
- Find what: ^.+?
- Change to: L$0
- Search: Selection
- Click Change All
What do you mean by part numbers?
I am not so good with grep, but trying this simple query helped me achieve what i could make out from your question.
I selected the portion of the table and then ran the grep ONLY on the selection.
This is what I get then by hitting on "Change All"..
Just to add, since it is not clear how the numbers are or what part numbers mean it is not clear what is the desired result.
Running John's grep gives me somewhat different result than mine since it even converts words other than numbers to Lwords.
Thanks so much John, this does exactly what I want. Saves me a lot of time.