Concatenate and remove

[labar0ness1]

Hello,
I need to concatenate two columns in order to compare data. However, after concatenating, I need to remove the first couple parts of the string.

Column A

<table width="211" border="0" cellpadding="0" cellspacing="0" height="48"><col width="37"><col width="54"><col width="76"><tr height="17"> <td class="xl66" style="height: 12.75pt; width: 28pt;" width="37" height="17">A
-----
4 9</td> <td class="xl65" style="width: 41pt;" width="54">B
--------
\\2\3 9\8</td> <td style="width: 57pt;" width="76">C
-------
"\\2\3 9\8\4 9"</td> </tr></table>
Formula: CONCATENATE(CHAR(34),B:B,A:A,CHAR(34))

I need to remove \\2\3 9 from the string.
Any assistance would be greatly appreciated.

 

[Nooblet]

Try

=CONCATENATE(CHAR(34),RIGHT(B:B,3),A:A,CHAR(34))

 

[labar0ness1]

Thanks so much! YAY!

 

[jjmktg]

I have a quesiton...

I have a column withe product numbers. The number of digits are different from cell to cell but I need to shave off the first four and leave the remainder.

For example:
A1 has B6849302
A2 has 14V2990002

I need to knock off the first four characters and leave the remainder in a cell. How do I do that?

 

[Peter_SSs]

Welcome to the MrExcel board!

Try
=REPLACE(A1,1,4,"")

 

[jjmktg]

Peter you are a GENIUS! I have absoluately NO idea how it works but it worked like a charm. You just saved me hours of pain!!

 

[Peter_SSs]

I have absoluately NO idea how it works

Just look up the REPLACE function in Excel's built-in Help

REPLACE(old_text, start_num, num_chars, new_text)

Old_text Required. Text in which you want to replace some characters.
Start_num Required. The position of the character in old_text that you want to replace with new_text.
Num_chars Required. The number of characters in old_text that you want REPLACE to replace with new_text.
New_text Required. The text that will replace characters in old_text.