Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a new field
Q. I have a street address that is divided into 4 fields in an excel
(2002) file. They are all text. I need to combine them into one field that I would name STREET. Is there a quick way of doing this. I am very much a beginner and need all the help I can get. Thank you. Michael Rodriguez |
#2
|
|||
|
|||
Hi
=A1 & " " & B1 & " " & C1 & " " & D1 -- Regards Frank Kabel Frankfurt, Germany "Michael Rodriguez" schrieb im Newsbeitrag om... Q. I have a street address that is divided into 4 fields in an excel (2002) file. They are all text. I need to combine them into one field that I would name STREET. Is there a quick way of doing this. I am very much a beginner and need all the help I can get. Thank you. Michael Rodriguez |
#3
|
|||
|
|||
Hi Michael,
Assume that your address dat is in cells A1:D1: In cell E1 enter the formula: =A1 & ", " &B1 & ", " & C1 & ", " & D1 --- Regards, Norman "Michael Rodriguez" wrote in message om... Q. I have a street address that is divided into 4 fields in an excel (2002) file. They are all text. I need to combine them into one field that I would name STREET. Is there a quick way of doing this. I am very much a beginner and need all the help I can get. Thank you. Michael Rodriguez |
#4
|
|||
|
|||
Thanks to all
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am having problems creating pivot table of data | Charts and Charting in Excel | |||
creating an x,y chart | Charts and Charting in Excel | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
how do you set up a mandatory field in Excel? | Excel Discussion (Misc queries) | |||
Creating Templates | Excel Discussion (Misc queries) |