rajncajn Posted December 3, 2009 Share Posted December 3, 2009 I have a large row of various number & I want to add a prefix to all the numbers. I could do the concatenate function, but that's a lot of hassle adding in new columns for the data, merging them & then deleting the old columns. Usually I do a Find & Replace if there is a specific character I can latch onto, but the data in the cells is all different in this case. Can I still do a Find & Replace and somehow tell it to replace the same data in the cell, but with the added prefix? Ex. Cell has FS004 in it, I need it to read LUT/FS004. Cell below it reads GA001, I need it to read LUT/GA001. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.