Quick simple tip on Excel formatting needed please

[Fanum]

I have a multi thousand line Excel sheet here.....

In one column are a set of text categories.......in the next column are some sub-categories (hundreds of them,all different, or I'd do through it manually and cut'n'paste)

Because there are only 8 different categories in column A, I successfully added the requisite "/" after each category by doing a 'find and replace', but what I need to do now is copy the content of column 'B' into, but AFTER the text in column 'A' (IE after the "/" that I just added, so it would go from one column saying "CategoryA/" and the neighbour "subcat1" to saying "CategoryA/subcat1" only, in the first column)



Hope that makes sense.....I'm sure there's a very easy way to do it, but I'm hopeless at Excel

TY

 

[1130cc]

In Excel you use a & join two "bits" together.

This explains what to do - http://www.mrexcel.com/tip074.shtml

 

[GrinningGSer]

Well, I am no Excel expert, but if you could do it once manually and record it with a keyboard macro programme, then you could leave it running

 

[walrus]

In a blank column = click 1st column&" "&click second column then copy that down the whole lot by dragging .

Eg. = A1&" "&B1. The " " adds a space.

I think!

 

[Fanum]

In Excel you use a & join two "bits" together.

This explains what to do - http://www.mrexcel.com/tip074.shtml

Thanks for that, very elegant ....looks like exactly what I was after, but it's a stone cold sober operation too (I'll probably have to come back to it tomorrow to follow it step by step...."Concatenation" FFS

Well, I am no Excel expert, but if you could do it once manually and record it with a keyboard macro programme, then you could leave it running

Now that I like too ......TY

It's cheap and it's dirty.......just the way I normally think, but I hadn't thought of that

I don't have a fancy macro KB but I have used macro recording gizmos that rely on pixel positions and mouse movements/clicks, so it is possible

In a blank column = click 1st column&" "&click second column then copy that down the whole lot by dragging .

Eg. = A1&" "&B1. The " " adds a space.

I think!

Erm.......



Thanks

(I'll see if I can make sense of that and try it )

 

[Fanum]

In Excel you use a & join two "bits" together.

This explains what to do - http://www.mrexcel.com/tip074.shtml

Well bugger me backwards with an oiled up otter....it worked

Thank you.....I owe you a pint

 

[1130cc]

No probs.

I use it a lot to stick columns together, or add other text to a value.