Apr 12 2020 12:53 AM
I have text on multiple lines in a column and I want to add a word to the front of each line of text.
example
COLUMN
time to sleep
go to work
you can play
I want to add the word "STUART" to each line in the column giving
STUART time to sleep
STUART go to work
STUART you can play
Apr 12 2020 02:57 AM - edited Apr 12 2020 03:01 AM
Apr 12 2020 03:13 AM - edited Apr 12 2020 03:15 AM
SolutionApr 14 2020 09:06 PM
I only looked at this today as I worked all of Easter. It work really well after I got the hang of it. Many thanks.
I have another question if that is ok.
When I export stock from Account Right to excel and include a Barcode that begins with a Zero it drops the Zero off.
I have used the same formula you gave me and it corrects it. Just had to remove the space between ""
My question is - Can I change the export or the cell features so the zero is there when I do the export rather than have to fix it each time?
Apr 15 2020 12:49 AM
Apr 12 2020 03:13 AM - edited Apr 12 2020 03:15 AM
Solution