I need to concatenate without the references.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 character columns that I want to concatenate into a third column and
then I need to get rid of the first 2 columns (without losing the text) e.g.
A1=Part No 5555/tool
B1=Brand=Vise-Grip
I need: [Part No 5555/tool Brand=Vise-Grip] NOT [=A1&" "&B1]
Is this possible???
 
Hi

Use =A1&" "&B1. Fill this down your column. Once you are happy with the
result, fix these values in place and then delete the first two columns.
To fix the values, select the column, Ctrl+C and then Edit/Paste
Special/Values

Hope this is what you meant!
Andy.
 
Select the third column, right click and copy, then right click again and
click paste special, then a window will pop up. Select paste as value and
your done
 
C1=Concatenate(A1,"/"B1)

Text = Part No 5555/Vise-Grip

If you are going to get rid of column A and B, the only way I know ho
to have the text is to copy the formula in column C and use the past
special option into Column D and paste only values. Then if you delet
Columns A B and C, the text remains.

Hope that's of hel
 
The others have given you the instructions on how to do your task, but I read
your post as tho you are doing that process but are actually getting the
formula =A1&" "&B1 displayed in C1 instead of the concatenation you desire.
Be that the case, it could be that your column C is just formatted as TEXT.
Try reformatting to General.

Vaya con Dios,
Chuck, CABGx3
 
YES!!!! Thank You!!!!! Awesome!!!

AndyB said:
Hi

Use =A1&" "&B1. Fill this down your column. Once you are happy with the
result, fix these values in place and then delete the first two columns.
To fix the values, select the column, Ctrl+C and then Edit/Paste
Special/Values

Hope this is what you meant!
Andy.

pmms said:
I have 2 character columns that I want to concatenate into a third column
and
then I need to get rid of the first 2 columns (without losing the text)
e.g.
A1=Part No 5555/tool
B1=Brand=Vise-Grip
I need: [Part No 5555/tool Brand=Vise-Grip] NOT [=A1&" "&B1]
Is this possible???
Click to expand...
Click to expand...
 
Back
Top