Hi,
I have a high amount of cells looking like this
D2-S1
T4-S8
P9-S10
And so on.
How can I add the text MASTER_ on all cells?
MASTER_D2-S1
MASTER_T4-S8
MASTER_P9-S10
-A-
Hi,
I have a high amount of cells looking like this
D2-S1
T4-S8
P9-S10
And so on.
How can I add the text MASTER_ on all cells?
MASTER_D2-S1
MASTER_T4-S8
MASTER_P9-S10
-A-
use:
=CONCATENATE("MASTER_",B1)
***B1 is the cell where your data is pasted
if possible kindly attached the sheet
excelf.xlsx
The format MUST be the same. Because I need to export the file into a iFix system.
what u want is "MASTER_" to be added in every cell value in coloum B without using formula
I that case u can use PASTE VALUE after applying formula
OR.
Use wfm007's formula in an empty column. Copy down as you need.
Then highlight this range >>>Copy>>>go To Column B1>>Paste special>>Only values>>OK.
Delete the "empty" column.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Ahh. NICE
Thanks!!!
-A-
........................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks