**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula where I can add word to a entire column .

Solved by E. E. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
09/02/2018 - 07:43

Hi there I expert.

Excelchat Expert
09/02/2018 - 07:43

hello

User
09/02/2018 - 07:44

So i use google sheets and excel

User
09/02/2018 - 07:44

is it possible to get formula for both or just excel?

Excelchat Expert
09/02/2018 - 07:44

okay

Excelchat Expert
09/02/2018 - 07:44

I can try for both

User
09/02/2018 - 07:45

So i have a column of #s and wondering how I can add a space and word or letter

User
09/02/2018 - 07:45

for the entire column

Excelchat Expert
09/02/2018 - 07:45

do you have the file with you

User
09/02/2018 - 07:46

can you see the document preview on right?

Excelchat Expert
09/02/2018 - 07:46

yes

User
09/02/2018 - 07:46

its not the whole file but example of the colum that needs

Excelchat Expert
09/02/2018 - 07:46

sure

User
09/02/2018 - 07:46

a space and USD next to each number

User
09/02/2018 - 07:46

(and for future, sometimes the space is not there just letter or word)

Excelchat Expert
09/02/2018 - 07:47

after the number or before

Excelchat Expert
09/02/2018 - 07:48

something like this

User
09/02/2018 - 07:48

after

Excelchat Expert
09/02/2018 - 07:48

ok

User
09/02/2018 - 07:48

or is there way to tweak the fromula for future where i can add before too if i ran into something that requires before?

User
09/02/2018 - 07:49

In this case, I need USD word not dollar sign

Excelchat Expert
09/02/2018 - 07:49

ok

Excelchat Expert
09/02/2018 - 07:50

if you know the criteria when you will need it before then

Excelchat Expert
09/02/2018 - 07:50

may be I can put an If formula for that

User
09/02/2018 - 07:50

perfect

Excelchat Expert
09/02/2018 - 07:51

if you need it before then just put the USD and space before in the formula

User
09/02/2018 - 07:52

Nice... i tried to find somethign like this but took me too many hrs

Excelchat Expert
09/02/2018 - 07:53

is there anything else you wanted to know

User
09/02/2018 - 07:53

where can i find the formula?

User
09/02/2018 - 07:53

i think i found it

Excelchat Expert
09/02/2018 - 07:53

yes next to the fx sign

User
09/02/2018 - 07:54

so i just do the drop down fill for the entire column after applying it to the first cell?

Excelchat Expert
09/02/2018 - 07:54

its called formula bar

User
09/02/2018 - 07:54

google sheets and excel are pretty similar right?

Excelchat Expert
09/02/2018 - 07:54

yes

User
09/02/2018 - 07:54

this formula should work with google sheets?

Excelchat Expert
09/02/2018 - 07:54

yes it should work

User
09/02/2018 - 07:55

ok so A2 if my column is M2

User
09/02/2018 - 07:55

then it should be replaced with that right

Excelchat Expert
09/02/2018 - 07:55

correct

User
09/02/2018 - 07:56

Is there way to quickly fill down with the remaining columns

User
09/02/2018 - 07:56

when i do fill down it goes all the way to the bottom like more then the sheet

User
09/02/2018 - 07:57

Like the sheet has 1000 rows right

User
09/02/2018 - 07:57

But my data has only 883 rows

Excelchat Expert
09/02/2018 - 07:57

you can drag down till the row you need

User
09/02/2018 - 07:57

so when i fill down it goes all the way to 1000

User
09/02/2018 - 07:57

When i drag it though and data is really big it can take quite long time

User
09/02/2018 - 07:58

and when i select the whole column it selects all 1000 and not 883

Excelchat Expert
09/02/2018 - 07:58

the other way to do is to go to the last used row of column A

Excelchat Expert
09/02/2018 - 07:59

move to column B and then select till top using shift arrow

Excelchat Expert
09/02/2018 - 07:59

and then do control D

Excelchat Expert
09/02/2018 - 07:59

ctrl+shift+d

User
09/02/2018 - 08:00

ok... or im doing similar formula to other columsn i can cut off the unused rows and im able to select all column and it will select all with data only right

Excelchat Expert
09/02/2018 - 08:00

ctrl+ arrow key can move to first or last cell

Excelchat Expert
09/02/2018 - 08:01

go to last row by using ctrl +arrow key

Excelchat Expert
09/02/2018 - 08:01

do ctrl+shift+up arrow

Excelchat Expert
09/02/2018 - 08:01

it will select till the last used row

Excelchat Expert
09/02/2018 - 08:01

do ctrl d

Excelchat Expert
09/02/2018 - 08:02

it will copy the formula till last

User
09/02/2018 - 08:02

ok... got it..

User
09/02/2018 - 08:02

thanks for helping me save lot of time

Excelchat Expert
09/02/2018 - 08:02

welcome

Excelchat Expert
09/02/2018 - 08:02

thanks and have a good day

User
09/02/2018 - 08:02

chipmunk .. you gave the name to yourself?

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*