More excel help : / Is it possible to put one word in front of all your data ?

[Lastoutkast]

so in a excel table is it possible to put one word in front of all your data ? as in I have CR [ 1/3 ] I want [CR 1/3] hope that make some kind of sense.

CR To CR
-- --
1/3 CR 1/3
-- --
1/4 CR 1/4

[Berik]

You mean say you have one cell with 1/3 and you want to format it as [CR 1/3] in another cell?

If 1/3 is in cell [A2] then you could have:
="[CR " & A2 & "]"

[Lastoutkast]

Berik wrote:

You mean say you have one cell with 1/3 and you want to format it as [CR 1/3] in another cell?

If 1/3 is in cell [A2] then you could have:
="[CR " & A2 & "]"

Something like this.

https://docs.google.com/spreadsheets/d/1qHtNwtubBcbW26yyQGnxfNAlbLhma99qRSK WyfFstjY/edit?usp=sharing

[Berik]

Getting an error trying to open that file sorry. Though what I posted will work if you have say one column with all the CR's and then want the column beside it to give the formatted version.

[Lastoutkast]

Berik wrote:

Getting an error trying to open that file sorry. Though what I posted will work if you have say one column with all the CR's and then want the column beside it to give the formatted version.

That makes sense, but is there a way to go those all the tables at ones?

="[CR " & A2:A17 & "]"

Because I keep getting an error message when I try :/

[Berik]

Well, if you put the original formula in B2 then you could drag the formula down to cell B17 and then you'd get all of those cells populated at once. Looking something like the below.

1/3 [CR 1/3]
1/2 [CR 1/2]
1 [CR 1]
...
5 [CR 5]

(If you don't know what I mean by 'drag the formula down' it just means that if you click the bottom right of the cell with the formula in and drag down, you'll copy the formula to all of the cells you highlight.)

[Lastoutkast]

Berik wrote:

Well, if you put the original formula in B2 then you could drag the formula down to cell B17 and then you'd get all of those cells populated at once. Looking something like the below.

1/3 [CR 1/3]
1/2 [CR 1/2]
1 [CR 1]
...
5 [CR 5]

(If you don't know what I mean by 'drag the formula down' it just means that if you click the bottom right of the cell with the formula in and drag down, you'll copy the formula to all of the cells you highlight.)

And two hours later I figured it out :)

Thank you !!!

[Berik]

No worries, happy to help!

[Cevah]

Lastoutkast wrote:

Berik wrote:

Getting an error trying to open that file sorry. Though what I posted will work if you have say one column with all the CR's and then want the column beside it to give the formatted version.

That makes sense, but is there a way to go those all the tables at ones?

="[CR " & A2:A17 & "]"

Because I keep getting an error message when I try :/

Actually there is.

Instructions for Array Formulas:

Say you have A2:A17 with your CR#s, and you want B2:B17 to be the result.
Steps:
1) Select B2:B17
2) Enter the formula ="[CR "&A2:A17&"]" into the formula bar directly. DO NOT PRESS ENTER
3) Press Control+Shift+Enter

Your formula now appears with "{}" surrounding it, indicating it is a single formula for the whole range.

Cells B2:B17 now appear as you desire.

/cevah