# Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.