SOLVED

SEARCH AND REPLACE

%3CLINGO-SUB%20id%3D%22lingo-sub-1300686%22%20slang%3D%22en-US%22%3ESEARCH%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1300686%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20text%20on%20multiple%20lines%20in%20a%20column%20and%20I%20want%20to%20add%20a%20word%20to%20the%20front%20of%20each%20line%20of%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%3C%2FP%3E%3CP%3ECOLUMN%3C%2FP%3E%3CP%3Etime%20to%20sleep%3C%2FP%3E%3CP%3Ego%20to%20work%3C%2FP%3E%3CP%3Eyou%20can%20play%3C%2FP%3E%3CP%3EI%20want%20to%20add%20the%20word%20%22STUART%22%20to%20each%20line%20in%20the%20column%20giving%26nbsp%3B%3C%2FP%3E%3CP%3ESTUART%20time%20to%20sleep%3C%2FP%3E%3CP%3ESTUART%20go%20to%20work%3C%2FP%3E%3CP%3ESTUART%20you%20can%20play%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1300686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1300806%22%20slang%3D%22en-US%22%3ERe%3A%20SEARCH%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1300806%22%20slang%3D%22en-US%22%3EYou%20can%20use%20Flash%20Fill%3CBR%20%2F%3EAssume%20you%20have%3CBR%20%2F%3Etime%20to%20sleep%20in%20cell%20A1%3CBR%20%2F%3Ego%20to%20work%20in%20cell%20A2%3CBR%20%2F%3Eyou%20can%20play%20in%20cell%20A3%3CBR%20%2F%3E%3CBR%20%2F%3EAnd%20you%20want%20to%20add%20STUART%20as%20your%20prefix%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20cell%20B1%2C%20type%3A%20%3CBR%20%2F%3ESTUART%20time%20to%20sleep%20%3CBR%20%2F%3EClick%20Enter%3CBR%20%2F%3EPress%20CTRL%20%2B%20E.%3CBR%20%2F%3E%3CBR%20%2F%3ESTUART%20will%20be%20prefixed%20%3CBR%20%2F%3EThat's%20all.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20this%20answers%20your%20question%20easily%2C%20do%20accept%20as%20the%20Best%20Response.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1300823%22%20slang%3D%22en-US%22%3ERe%3A%20SEARCH%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1300823%22%20slang%3D%22en-US%22%3EYou%20can%20also%20use%20a%20formula%20to%20make%20it%20dynamic%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%22STUART%22%26amp%3B%22%20%22%26amp%3BA1.%20Click%20Enter.%20This%20will%20return%20STUART%20time%20to%20sleep%20in%20cell%20B1%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20you%20can%20use%20Fill%20Handle%20to%20copy%20down%20the%20formula%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1308048%22%20slang%3D%22en-US%22%3ERe%3A%20SEARCH%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308048%22%20slang%3D%22en-US%22%3E%3CP%3EI%20only%20looked%20at%20this%20today%20as%20I%20worked%20all%20of%20Easter.%20It%20work%20really%20well%20after%20I%20got%20the%20hang%20of%20it.%20Many%20thanks.%3C%2FP%3E%3CP%3EI%20have%20another%20question%20if%20that%20is%20ok.%3C%2FP%3E%3CP%3EWhen%20I%20export%20stock%20from%20Account%20Right%20to%20excel%20and%20include%20a%20Barcode%20that%20begins%20with%20a%20Zero%20it%20drops%20the%20Zero%20off.%3C%2FP%3E%3CP%3EI%20have%20used%20the%20same%20formula%20you%20gave%20me%20and%20it%20corrects%20it.%20Just%20had%20to%20remove%20the%20space%20between%20%22%22%3C%2FP%3E%3CP%3EMy%20question%20is%20-%20Can%20I%20change%20the%20export%20or%20the%20cell%20features%20so%20the%20zero%20is%20there%20when%20I%20do%20the%20export%20rather%20than%20have%20to%20fix%20it%20each%20time%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1308463%22%20slang%3D%22en-US%22%3ERe%3A%20SEARCH%20AND%20REPLACE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308463%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20wrote%20a%20blog%20on%20adding%20leading%20zeros.%20Kindly%20check%20the%20blog%20post%20below%20which%20answers%20the%20question%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.exceljetconsult.com.ng%2Fhome%2Fblog%2Fhow-to-add-leading-zero-to-nigerias-mobile-number%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.exceljetconsult.com.ng%2Fhome%2Fblog%2Fhow-to-add-leading-zero-to-nigerias-mobile-number%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

4 Replies
Highlighted
You can use Flash Fill
Assume you have
time to sleep in cell A1
go to work in cell A2
you can play in cell A3

And you want to add STUART as your prefix

In cell B1, type:
STUART time to sleep
Click Enter
Press CTRL + E.

STUART will be prefixed
That's all.

If this answers your question easily, do accept as the Best Response.
Highlighted
Best Response confirmed by STUART_1955 (New Contributor)
Solution
You can also use a formula to make it dynamic

="STUART"&" "&A1. Click Enter. This will return STUART time to sleep in cell B1

Then you can use Fill Handle to copy down the formula
Highlighted

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?

Highlighted
Hello,

I wrote a blog on adding leading zeros. Kindly check the blog post below which answers the question

https://www.exceljetconsult.com.ng/home/blog/how-to-add-leading-zero-to-nigerias-mobile-number/