Automatically add text to a cell with text in it

[grimsbyelec]

Re: Text String And I Want To Add text Automatically

--------------------------------------------------------------------------------

Hello

I have E2 that has my first brand name in, and in c2 and d2 i have my product title and url text,

I am trying to figure out how i can make the spreadsheet automatically copy the brand name to the start of the descriptions in C2 and D2 without losing any of the text,

i.e. at the moment C2 D2 E2
4-IN-1 BIKINI TRIMMER 4-IN-1 BIKINI TRIMMER PHILLIPS

What i need is:

C2 D2 E2
PHILLIPS 4-1 BIKINI TRIMMER PHILLIPS 4-1 BIKINI TRIMMER PHILLIPS


Can this be done?

[davesexcel]

VBA solution

Please Login or Register  to view this content.

[grimsbyelec]

Hi i am not very good with excel where would i need to put that?

[davesexcel]

Where does the code go
Check this out
Hit Alt+F11 to get to the VBA editor
You need to insert a module and paste the code there.
Hit Alt+F11 again to get back to the Worksheet, F8 will show the macro window, run the selected macro.

Awaiting the next question....please attach a sample workbook with it.