Copy Cell in excel and add text to copyed content.

Hi
Im trying to simplify a task in excel, and i need to copy text from cell A “purple” and paste this inn cell N m:\path\to\picture\server\purple.jpg

cell A2 contains: “purple
cell N2 is empthy and ends up with: m:\path\to\picture\server[b]purple[/b].jpg
cell A3 contains: “blue
cell N3 is empthy and ends up with: m:\path\to\picture\server[b]blue[/b].jpg
cell A4 contains: “black
cell N4 is empthy and ends up with: m:\path\to\picture\server[b]black[/b].jpg¨

I have the copy from cell to cell giong, but how do i insert my clippboard betwene "server/ and .jpg

Help please?:heart:

Belatedly, to my mind, this is better suited to applescript than automator but assuming that your workflow already has the workbook open and the worksheet active, then you could probably add a ‘run applescript’ action which contains the following applescript code.

on run {input, parameters}
	
	tell application "Microsoft Excel"
		tell active sheet of active workbook
			
			set lString to "m:\\path\\to\\picture\\server\\"
			set rString to ".jpg"
			
			set aRg to range "A2:A4"
			set nRg to range "N2:N4"
			repeat with x from 1 to count of cells of aRg
				set value of cell x of nRg to lString & value of cell x of aRg & rString
			end repeat
			
		end tell
	end tell
	
	return input
end run

There isn’t likely a need to use the clipboard for this type of task. Just determine the strings —note that each backslash in the path requires its own backslash— and then loop through the ranges to assemble the final strings and place them into the appropriate cell.

What happens with each cell is this:
[format]set value of cell 1 of range “N2:N4” of active sheet of active workbook to “m:\path\to\picture\server\purple.jpg”[/format]